Sqlserver 2008R2

We have installed sqlserver 2008r2 on windows server 2008 (64bits)in development. Did I make the right choices to install sqlserver 2008R2 rather than using sqlserver 2008? Also I would like to install sqlserver 2008R2 service pack 1. Do I download both SQLServer2008R2SP1-KB2528583-x64-ENU.exe as well as SQLManagementStudio_x64_ENU.exe
more ▼

asked May 10, 2012 at 08:14 PM in Default

Chitrarekha gravatar image

140 34 42 43

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Did you make the right choice? Well, it is always good to use the current version or the next best thing to the most current release (SQL 2012 being the latest).

The SQLManagementStudio install is for patching SSMS usually on client machines, like your desktop or laptop, where you might only have SSMS instead of all SQL components installed. I believe SP1 install will patch SSMS if it is detected but not positive. You could download both and then just run SP1 and verify that SSMS is running at SP1 build, if not then apply the second exe as well.
more ▼

answered May 10, 2012 at 08:22 PM

Shawn_Melton gravatar image

5.4k 20 21 29

Well at this time we do not want to go to sqlserver 2012 so my question is did I make the right choice installing sqlserver 2008 or 2008R2.
May 10, 2012 at 08:31 PM Chitrarekha
I can tell you yes you made the right choice, but your choice should really follow business/application requirements. If the applications are compatible with the newer version then go with the newer version. When you consider support life cycle then it is always a better choice to go with the newer version.
May 10, 2012 at 08:36 PM Shawn_Melton
Thank you! My applications supports sqlserver 2008R2
May 10, 2012 at 08:40 PM Chitrarekha
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: May 10, 2012 at 08:14 PM

Seen: 741 times

Last Updated: May 10, 2012 at 08:46 PM