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

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

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s