question

Chitrarekha avatar image
Chitrarekha asked

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
sql-server-2008patchingrecommendation
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Shawn_Melton avatar image
Shawn_Melton answered
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.
3 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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.
2 Likes 2 ·
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.
0 Likes 0 ·
Thank you! My applications supports sqlserver 2008R2
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.