SQL Service can not be restarted due to errors of upgrade step

Errors:

Script level upgrade for database 'master' failed because upgrade step 'sqlagent100_msdb_upgrade.sql' encountered error 5833, 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.

 

Analysis:

Solution:

Use below commands to start service with trace flag 902

NET START MSSQLSERVER /T902->for default instance

NET START MSSQL$INSTANCENAME /T902->for named instance

 

posted @ 2018-12-10 14:51  rosewong  阅读(289)  评论(0编辑  收藏  举报