How to rollback patch on sql server 2016

Tith Sineath 1 Reputation point
2020-10-26T01:39:57.647+00:00

Hello Team,

Currently, we already applied patch the latest version of sql server 2016, and we check version it show the latest version also. But in case if I want to rollback patch that I already applied, how to rollback it?

Anyone know about this?

Best regards,

Sineath

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,815 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor
    2020-10-26T02:26:52.46+00:00

    Hi @Tith Sineath ,

    You can uninstall the SP and CU of SQL Server from Control Panel\Programs\Programs and Features\ Installed Updates.
    34912-1.jpg
    After uninstalling it, SQL Server will roll back to previous version.

    Best Regards,
    Amelia

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.
    0 comments
  2. RatheeshKNair 6 Reputation points
    2020-10-26T02:29:32.533+00:00

    You can uninstall the SP from the programmes & Features in Control Panel.

    Control Panel-->Programs & Features search for SQL server and you can find the installed updates & service packs. You can right-click and uninstall from there.

    0 comments