Symptoms

Assume that you have a database snapshot on a pull subscription database on a server that is running Microsoft SQL Server. When you apply a hotfix on the server, the script-level upgrade fails, and you receive an error message that resembles the following:

date time spid_number Performing replication job security meta-data upgrades...
date time
spid_number Error: 3906, Severity: 16, State: 1.
date time
spid_number Failed to update database "database_name" because the database is read-only.
date time
spid_number Error: 912, Severity: 21, State: 2.
date time
spid_number Script level upgrade for database 'master' failed because upgrade step 'msdb110_upgrade.sql' encountered error 3906, state 1, severity 16. This is a serious error condition which might interfere with regular operation and the database will be taken offline. If the error happened during upgrade of the 'master' database, it will prevent the entire SQL Server instance from starting. Examine the previous errorlog entries for errors, take the appropriate corrective actions and re-start the database so that the script upgrade steps run to completion.

Resolution

This problem is fixed in the following updates for SQL Server:

          Cumulative Update 9 for SQL Server 2017

Cumulative Update 2 for SQL Server 2016 Service Pack 2

Cumulative Update 10 for SQL Server 2016 Service Pack 1

Cumulative Update 13 for SQL Server 2014 SP2

About SQL Server builds

Each new build for SQL Server contains all the hotfixes and security fixes that were in the previous build. We recommend that you install the latest build for your version of SQL Server:

Latest cumulative update for SQL Server 2017

The latest build for SQL Server 2016

Latest cumulative update for SQL Server 2014

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References

Learn about the terminology Microsoft uses to describe software updates.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Any additional feedback? (Optional)

Thank you for your feedback!

×