SQL Server 2008 R2 Service Pack Install Procedure
Posted on 2013-01-31
I have a 2008 R2 SQL Server that I have acquired that is currently in RTM release. There have been some performance errors in the log that appear to be resolved in Service Packs And update Roll ups. I plan on increasing the memory in the server and installing service pack 2 and release 4.
Some questions and concerns I have:
Can I just download the service pack 2 update and rollup 4, or would I need to install prior updates first and do it one at a time?
I plan on performing a full backup of the database prior to the upgrade, Is there anything else that I should be backing up so incase of a worst case scenario such a d server crash and I need to rebuild it, what I would need to have to be in the previous state.
I have several developer pcs that have SQL management studio installed on their workstations, do these need to be upgraded as well to correspond to the upgraded SQL version?
In case that something breaks or doesn't work correctly, is it easy to revert back to to the rtm release, meaning is I just a matter of going into programs and uninstalling the updates?
Any other precautions that should be taken or considered?
Any resources you can provide to assist with all the above questions and concerns are greatly appreciated.