服务启动/t902 数据库‘master‘的指令码层级升级失败,因为升级步骤‘msdb110_upgrade.sql‘发生错误824,状态2,严重性24
广告:
Script level upgrade for database 'master' failed because upgrade step 'msdb110_upgrade.sql' encountered error 824, state 2, severity 24. 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
Script level upgrade for database 'master' failed because upgrade step 'msdb110_upgrade.sql' encountered error 824, state 2, severity 24
資料庫 ‘master‘ 的指令碼層級升級失敗,因為升級步驟 ‘msdb110_upgrade.sql‘ 發生錯誤 824,狀態 2,嚴重性 24
数据库‘master‘的指令码层级升级失败,因为升级步骤‘msdb110_upgrade.sql‘发生错误824,状态2,严重性24
请在以前的错误日志条目中检查相关错误,采取相应的更正措施,然后重新启动数据库,以便完成脚本升级步骤。
解决办法,依旧是 将Beta:UTF8选项关闭
今天在测试环境对SQLServer2016安装SP3补丁的时候报错,然后再启动数据库服务的时候报下面的错误,重启服务器错误仍旧存在
可参照处理:
http://www.ysneo.com/news/detail/20897.html
消息 2775,级别 17,状态 12,第 65089 行
服务器不支持代码页 65001。
Uploading instmdw.sql from disk: D:\Program Files\Microsoft SQL Server\MSSQL14.SQL2017\MSSQL\Install\instmdw.sql
消息 515,级别 16,状态 2,过程 dbo.sp_syscollector_upload_instmdw,行 64 [批起始行 65087]
不能将值 NULL 插入列 'parameter_value',表 'msdb.dbo.syscollector_blobs_internal';列不允许有 Null 值。INSERT 失败。
广告: