服務啟動/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.tjsimaide.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 失敗。
廣告: