14:54:26.07 spid6s Online index operations can only be performed in Enterprise edition of SQL Server. 'ISServer_upgrade.SQL' was adding tables and indexes to database SSISDB.ĬREATE NONCLUSTERED INDEX 14:06:20.81 spid6s SQL Server shutdown has been initiatedĪdded Trace Flag 3601 to startup and looked at SQL Error Log again to see what was being run in the script. For more information about how to rebuild the master database, see SQL Restore master from a full backup, repair it, or rebuild it. 14:06:20.81 spid6s Cannot recover the master database. Examine the previous errorlog entries for errors, take the appropriateĬorrective actions and re-start the database so that the script upgrade steps run to completion. If the error happened during upgrade of the 'master' database, it will prevent the entire SQL Server instance from starting. With regular operation and the database will be taken offline. This is a serious error condition which might interfere 14:06:20.80 spid6s Script level upgrade for database 'master' failed because upgrade step 'ISServer_upgrade.sql' encountered error 917, state 1, severity 15. Check the previous error message for the line which caused compilation to fail. 14:06:20.80 spid6s An upgrade script batch failed to execute for database 'master' due to compilation error. 14:06:20.80 spid6s Online index operations can only be performed in Enterprise edition of SQL Server. 14:06:20.44 spid6s Setting database option SINGLE_USER to ON for database 'SSISDB'. 14:06:20.43 spid6s Taking SSISDB to single user mode 14:06:20.43 spid6s Starting execution of ISServer_upgrade.SQL Part of the SQL Error Log Shows the following:ĭatabase 'master' is upgrading script 'ISServer_upgrade.sql' from level 0 to level 500. The upgrade failed and the Database Engine would not start. Last week I performed an upgrade in place of an SQL Server 2016 Standard Edition to SQL Server 2017 Standard Edition.
0 Comments
Leave a Reply. |