• 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

  • 相关阅读:
    ios录音
    ios 音乐播放
    ios程序播放音频文件
    ios摇一摇截屏代码
    加速计
    蓝牙4.0实现及原理
    物理仿真
    iOS 监听耳机变化
    删除缓存
    宏定义加参数
  • 原文地址:https://www.cnblogs.com/roseHLF/p/10096460.html
Copyright © 2020-2023  润新知