912

2019 (15.x) and later - Windows only

Product

Name

Event ID

912

Event

Source

MSSQLSERVER

Component

SQLEngine

Symbolic

Name

DB_RUNSCRIPTUPGRADE_STEP_FAILED

Message

Text

Script level upgrade for database ’%.*ls’ failed because upgrade step ’%.*ls’ encountered

error %d, state %d, severity %d. 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.

Error 912 indicates that the database script failed to be executed and to upgrade the

database(s) to the latest level required by the server. It is a general error message that contains

a reference to the upgrade script that failed and what error the failed script encountered.

When SQL Server is upgraded or a Cumulative Update is applied, only the binaries are

upgraded initially. The database and its objects remain unmodified. Once the binaries are

replaced with new versions and the service restarts for the first time, a database upgrade is

started. The upgrade scripts to be executed are located under C:\Program Files\Microsoft SQL

Server\MSSQLXX.YYYY\MSSQL\Install.

If the upgrade process encounters script-level upgrade errors (Error 912), other errors may be

raised. For example, these errors may accompany error 912 and help further explain the failure:

ﾉ

Expand table