Your company's ad could live here and reach over 50,000 people a month!

Share This Post

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

image

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

image

Right click, Uninstall

image

Uninstall update for SQL Server 2012: Click Next >

image

Click Next >

image

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

image

Click Remove

image

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

image

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.

image

Post SP2 Rollback, verification:

image

Filed under: SQL Server, SQL Server 2012

Share This Post

Leave a Reply