SQL Server 2016 database offline during patching

Anonymous
2021-09-14T21:00:20.44+00:00

We have a SQL Server 2016 instance with some databases offline that needs patching. If we patch the server will the offline databases be patched when they are brought online?

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,756 questions
0 comments
Accepted answer
  1. CathyJi-MSFT 21,096 Reputation points Microsoft Vendor
    2021-09-15T06:21:41.57+00:00

    Hi @Anonymous ,

    1. Applying CU12 to SQL 2019, then check the SQL server error log. It shows the information about databases upgrade. Database Node4 is offline in my environment.

    >Could not open database [node4]. Replication settings and system objects could not be upgraded. If the database is used for replication, run sp_vupgrade_replication in the [master] database when the database is available.

    132276-screenshot-2021-09-15-140716.jpg

    2..Bring the database node4 online, then check the error log. I did not find any information about database node4 upgrade.

    132180-screenshot-2021-09-15-140041.jpg

    3.... Restart the SQL server instance, then check the error log. I still did not find any information about database node4 upgrade.

    If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar thread.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 101.4K Reputation points MVP
    2021-09-14T21:12:27.727+00:00

    If you by patching mean applying service pack or cumulative updates,
    patching does not affect the user databases. That only applies if you upgrade the instance to a newer version of SQL Server.

    Patching affect the executables, and possible also the master, msdb and the resource databases.