Skip to content

Latest commit

 

History

History
72 lines (47 loc) · 3.94 KB

uninstall-a-cumulative-update-from-sql-server.md

File metadata and controls

72 lines (47 loc) · 3.94 KB
Raw
title description author ms.author ms.date ms.service ms.subservice ms.custom ms.topic helpviewer_keywords
Uninstall a Cumulative Update from SQL Server
This article describes how to remove a Cumulative Update from a stand-alone instance of SQL Server.
rwestMSFT
randolphwest
12/20/2022
sql
install
linux-related-content
conceptual
removing CU from SQL Server
uninstalling CU from SQL Server
removing Cumulative Update from SQL Server
uninstalling cumulative update from SQL Server
uninstall SQL Server CU

Uninstall a Cumulative Update from SQL Server

[!INCLUDE_ssnoversion]

This article describes how to remove a Cumulative Update (CU) from a stand-alone instance of [!INCLUDEssNoVersion], on both Windows and Linux.

To uninstall [!INCLUDEssNoVersion] on Windows, see Uninstall SQL Server.

Considerations

  • To remove a CU on [!INCLUDEssNoVersion], you must be a local administrator.

Prepare

  1. Back up your data. Create full backups of all databases. The master database contains all system level information for the instance, such as logins, and schemas. The msdb database contains job information such as [!INCLUDEssNoVersion] Agent jobs, backup history, and maintenance plans. For more information about system databases, see System databases.

  2. Stop all [!INCLUDEssNoVersion] services. We recommend that you stop all [!INCLUDEssNoVersion] services before you uninstall a Cumulative Update. Active connections can prevent successful removal.

  3. Use an account that has the appropriate permissions. Sign in to the server by using the [!INCLUDEssNoVersion] service account or by using an account that has equivalent permissions. For example, you can sign in on Windows with an account that is a member of the local Administrators group. On Linux, you should run the commands using the root account.

Remove a Cumulative Update on Windows

Depending on the version of Windows you're using, you can access the list of installed updates in several ways.

Locate the list of installed updates

For Windows Server 2016, Windows 10, and later versions:

  1. Open the Start menu, and type update history.
  2. Select View update history from the search results.
  3. Select Uninstall updates.

For older versions of Windows, navigate to Control Panel > Programs and Features > View installed updates.

Remove the Cumulative Update

Depending on the version of Windows you're using, you can remove the CU from the list of installed updates by either selecting the Uninstall option next to the update, or by right-clicking on the update and selecting Uninstall.

Follow the instructions to remove the CU. You may be prompted to restart your computer after the CU is removed.

Remove a Cumulative Update on Linux

To uninstall a Cumulative Update on Linux, you must roll back the package to the previous version.

[!INCLUDEroll-back-sql-server]

In the event of failure

If the removal process fails, review the SQL Server Setup log files to determine the root cause.

Next steps