Patching SQL Server and SSMS? Order matters.

Patching SQL Server
Patching SQL Server
If you’ve been living under a rock, you may not have noticed how frequently SSMS is getting updated. The SQL Team is really rocking over at Microsoft putting out fixes and enhancements fast and furious. When CUs (cumulative updates) and SPs (service packs) come out, it makes sense to install the latest SSMS update at the same time (if you put SSMS on your servers). If applying both an SP or CU along with an SSMS update, order does matter.

It doesn’t matter in a critical way (you’re not going to break anything if you do it in a different order), but you can save yourself some trouble. In my experience, the current SSMS updates almost always require a reboot after running the update. This is true for both the full install package and the update install package. If you update SSMS first, you will have to reboot before patching SQL Server. If you patch SQL Server first, you will almost always be able to update SSMS without rebooting first. Also in my experience, the reboot for the SSMS update isn’t critical. It can wait for a more convenient time to reboot if need so.

So remember: patch SQL Server first, and then SSMS.

Reposted with permission from SQLSoldier.com.

54321
(1 vote. Average 5 of 5)
Leave a reply

Your email address will not be published. Required fields are marked *