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

avatar image

140 37 42 45

(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

avatar image

6.6k 21 26 34

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.

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: 879 times

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

Copyright 2018 Redgate Software. Privacy Policy