question

HollomonBrett-7671 avatar image
0 Votes"
HollomonBrett-7671 asked ErlandSommarskog commented

SQL Server 2016 database offline during patching

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-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered HollomonBrett-7671 commented

Hi @HollomonBrett-7671,

  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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks for your help!

0 Votes 0 ·
ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered ErlandSommarskog commented

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.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks for the reply. However when we do our monthly patching (like SP2CU17) it goes through all databases twice, once it says updating publications and the next time it says subscriptions.

0 Votes 0 ·
ErlandSommarskog avatar image ErlandSommarskog HollomonBrett-7671 ·

Sorry, I was not aware of that. I don't use replication much myself, so I have not been paying attention.

1 Vote 1 ·