How to uninstall a SQL Server 2016 Cumulative Update

27 August,2019 by Jack Vamvas

Question: A server experienced a few problems after the installation of a SQL Server 2016 Cumulative Update. As part of the troubleshooting process, I'd like to rollback the cumulative update and rule out any issues related to the Cumulative update. How can I uninstall the cumulative update?

Answer: Uninstalling the cumulative update in SQL Server 2016 is straightforward. I've copied an pasted these 3 steps straight from the Microsoft  website

  1. In Control Panel, select View installed updates under Programs and Features.
  2. Locate the entry that corresponds to this cumulative update package under Microsoft SQL Server 2016.
  3. Press and hold (or right-click) the entry, and then select Uninstall.

Hot_fix_uninstall

You'll notice in the example , the description mentions HotFix - which you may find confusing , but focus on the KB number

 

If you're interested in using Powershell - you can try these commands to view the information

To view the hotfixes on a server , along with Installed Date , Description , HotFixID , InstalledBY etc , run this command on the sever

 wmic qfe list 

 

Read more about managing SQL Server cumulative updates 

Use Powershell Get-Hotfix to get all hotfixes on Windows server ...

Get cumulative update number for SQL Server Version

Powershell List all Patches Updates on a Server


Author: Jack Vamvas (http://www.sqlserver-dba.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on How to uninstall a SQL Server 2016 Cumulative Update


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer