Rollback procedure for SQL Server updates

As a follow-up to the post, how to install a service pack for a SQL Server cluster, it is important to have the ability to roll back an update. Fortunately, Microsoft has made this process fairly easy.

The following process was followed to remove SQL Server 2012 SP2 CU3 from a two node cluster. The identical procedure would be used to remove a SQL Server Service Pack.

Start by uninstalling SQL Server 2012 Sp2 CU3

On the Passive Node

Control Panel Add/Remove Programs > Click: View Installed Updates


Under Microsoft SQL Server 2012, Select Hotfix 5556 (CU3)


Right click, Uninstall


Uninstall update for SQL Server 2012: Click Next >


Click Next >


Check Files in use, once complete, and Click Next >


Click Remove


Next steps:

Reboot passive node.

Failover Active Node to passive node.

Repeat Uninstall update for SQL Server 2012 process on now passive node.

Validate SQL Server 2012 version:

Select @@Version


To remove the SQL Server 2012 SP2, use Control Panel, Uninstall Programs, show updates, then select and right click the Service Pack 2 and Uninstall. The remainder of the uninstall process is exactly the same technique as removing the CU update.


Post SP2 Rollback, verification:


This entry was posted in SQL Server, SQL Server 2012. Bookmark the permalink.

1 Response to Rollback procedure for SQL Server updates


    Do you have to stop the sql server service before you remove the hotfix _

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.