• 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

  • 相关阅读:
    个人附加作业
    个人最终总结
    结对作业--电梯调度
    VS2015安装&简单的C#单元测试
    C#程序代码分析(第三周)
    HTML学习有感
    gitlab使用有感之坚持
    学习有感

    Activity总结
  • 原文地址:https://www.cnblogs.com/roseHLF/p/10096460.html
Copyright © 2020-2023  润新知