服務(wù)啟動(dòng)/t902 數(shù)據(jù)庫‘master‘的指令碼層級(jí)升級(jí)失敗,因?yàn)樯?jí)步驟‘msdb110_upgrade.sql‘發(fā)生錯(cuò)誤824,狀態(tài)2,嚴(yán)重性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‘ 的指令碼層級(jí)升級(jí)失敗,因?yàn)樯?jí)步驟 ‘msdb110_upgrade.sql‘ 發(fā)生錯(cuò)誤 824,狀態(tài) 2,嚴(yán)重性 24
數(shù)據(jù)庫‘master‘的指令碼層級(jí)升級(jí)失敗,因?yàn)樯?jí)步驟‘msdb110_upgrade.sql‘發(fā)生錯(cuò)誤824,狀態(tài)2,嚴(yán)重性24
請(qǐng)?jiān)谝郧暗腻e(cuò)誤日志條目中檢查相關(guān)錯(cuò)誤,采取相應(yīng)的更正措施,然后重新啟動(dòng)數(shù)據(jù)庫,以便完成腳本升級(jí)步驟。
解決辦法,依舊是 將Beta:UTF8選項(xiàng)關(guān)閉
今天在測(cè)試環(huán)境對(duì)SQLServer2016安裝SP3補(bǔ)丁的時(shí)候報(bào)錯(cuò),然后再啟動(dòng)數(shù)據(jù)庫服務(wù)的時(shí)候報(bào)下面的錯(cuò)誤,重啟服務(wù)器錯(cuò)誤仍舊存在
可參照處理:
http://www.jdki.com.cn/news/detail/20897.html
消息 2775,級(jí)別 17,狀態(tài) 12,第 65089 行
服務(wù)器不支持代碼頁 65001。
Uploading instmdw.sql from disk: D:\Program Files\Microsoft SQL Server\MSSQL14.SQL2017\MSSQL\Install\instmdw.sql
消息 515,級(jí)別 16,狀態(tài) 2,過程 dbo.sp_syscollector_upload_instmdw,行 64 [批起始行 65087]
不能將值 NULL 插入列 'parameter_value',表 'msdb.dbo.syscollector_blobs_internal';列不允許有 Null 值。INSERT 失敗。
廣告: