I’m still not sure about why this script got run as no service packs / cumulative updates had been applied to this server recently and it was originally installed as 2008, not an upgrade from 2005. The upgrade script that SQL Server ran at startup performed a join across those two databases resulting in the error. Master was using SQL_Latin1_General_CP1_CI_AS while only msdb and one other database was using Latin1_General_CI_AS. It turns out that the collation of msdb did not match master. This is an informational message only preser action is required. SQL Trace was stopped due to server shutdown. For more information about how to rebuild the master database, see SQL Server Books Online. Restore master from a full backup, repair it, or rebuild it. 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.Ĭannot recover the master database. If the error happened during upgrade of the ‘master’ database, it will prevent the entire SQL Server instance from starting. This is a serious error condition which might interfere with regular operation and the database will be taken offline. Script level upgrade for database ‘master’ failed because upgrade step ‘sqlagent100_msdb_upgrade.sql’ encountered error 200, state 7, severity 25. And I found this in the SQL Error Log:Ĭreating procedure sp_sqlagent_get_perf_counters…Ĭannot resolve the collation conflict between “SQL_Latin1_General_CP1_CI_AS” and “Latin1_General_CI_AS” in the equal to operation. I started digging in and this is what I found in the Event Log: “Script level upgrade for database ‘master’ failed because upgrade step ‘sqlagent100_msdb_upgrade.sql’ encountered error 200, state 7, severity 25.” Immediately I started to suspect a corrupt master database. A few weeks ago one of our clustered server nodes blue-screened and when it came back on SQL refused to start.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |