SQL Server 2016安装SP3补丁的时候报错，由于升级步骤'msdb110_upgrade.sql'遇到错误200(状态7，严重性25)，因此数据库'master'的脚本级别升级
发布时间：2024/12/6 10:22:39 作者：Admin 阅读：49
广告：
问题：今天在测试环境对SQL Server 2016安装SP3补丁的时候报错，然后再启动数据库服务的时候报下面的错误，重启服务器错误仍旧存在。由于升级步骤 'msdb110_upgrade.sql' 遇到错误 200(状态 7，严重性 25)，因此数据库 'master' 的脚本级别升级失败。这是一种错误情况，可能会妨碍正常操作，且数据库将脱机。如果在 'master' 数据库升级过程中发生该错误，将阻止整个 SQL Server 实例启动。请在以前的错误日志条目中检查相关错误，采取相应的更正措施，然后重新启动数据库，以便完成脚本升级步骤。 无法恢复 master 数据库。SQL Server 无法运行。请利用完整备份还原 master 数据库，修复它，或者重新生成它。有关如何重新生成 master 数据库的详细信息，请参阅 SQL Server 联机丛书。2022-08-19 20:50:45.50 spid9s Uploading data collector package from disk: C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Install\SqlTraceCollect.dtsx2022-08-19 20:50:45.51 spid9s Uploading data collector package from disk: C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Install\SqlTraceCollect.dtsx2022-08-19 20:50:45.51 spid9s Error: 2775, Severity: 17, State: 12.2022-08-19 20:50:45.51 spid9s The code page 65001 is not supported by the server.2022-08-19 20:50:45.51 spid9s Error: 912, Severity: 21, State: 2.2022-08-19 20:50:45.51 spid9s Script level upgrade for database 'master' failed because upgrade step 'msdb110_upgrade.sql' encountered error 200, state 7, severity 25. 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.2022-08-19 20:50:45.51 spid9s Error: 3417, Severity: 21, State: 3.2022-08-19 20:50:45.51 spid9s Cannot recover the master database. SQL Server is unable to run. Restore master from a full backup, repair it, or rebuild it. For more information about how to rebuild the master database, see SQL Server Books Online.2022-08-19 20:50:45.51 spid9s SQL Server shutdown has been initiated2022-08-19 20:50:45.51 spid9s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required
这是一篇受密码保护的文章，请输入密码进行访问：
广告：
相关文章
