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
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.
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.
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.
5 People are following this question.
