sql server升级后出错upgrade for database 'master' failed because upgrade step 'u_tables.sql' encountered
发布时间:2026/7/28 9:34:32 作者:Admin 阅读:10
广告:
2026-07-28 09:16:41.71 spid36s Parallel redo is shutdown for database 'TestDataDB' with worker pool size [2].
2026-07-28 09:16:41.79 spid19s Database 'master' is upgrading script 'u_tables.sql' from level 268436456 to level 268439721.
2026-07-28 09:16:41.79 spid19s Starting u_Tables.SQL at 28 Jul 2026 09:16:41:793
2026-07-28 09:16:41.79 spid19s This file creates all the system tables in master.
2026-07-28 09:16:41.79 spid19s drop view spt_values ....
2026-07-28 09:16:41.79 spid19s Creating view 'spt_values'.
2026-07-28 09:16:41.99 spid19s drop table spt_monitor ....
2026-07-28 09:16:41.99 spid19s Creating 'spt_monitor'.
2026-07-28 09:16:41.99 spid19s Grant Select on spt_monitor
2026-07-28 09:16:41.99 spid19s Insert into spt_monitor ....
2026-07-28 09:16:42.02 spid19s Error: 25641, Severity: 16, State: 0.
2026-07-28 09:16:42.02 spid19s For target, "package0.event_file", the parameter "filename" passed is invalid. Target parameter at index 0 is invalid
2026-07-28 09:16:42.02 spid19s Error: 912, Severity: 21, State: 2.
2026-07-28 09:16:42.02 spid19s Script level upgrade for database 'master' failed because upgrade step 'u_tables.sql' encountered error 25641, state 0, 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.
2026-07-28 09:16:42.02 spid19s Error: 3417, Severity: 21, State: 3.
2026-07-28 09:16:42.02 spid19s 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.
2026-07-28 09:16:42.02 spid19s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
2026-07-28 09:16:43.03 spid19s Error: 25725, Severity: 16, State: 1.
2026-07-28 09:16:43.03 spid19s An error occurred while trying to flush all running Extended Event sessions. Some events may be lost.
2026-07-28 09:16:43.04 spid23s The SQL Server Network Interface library could not deregister the Service Principal Name (SPN) [ MSSQLSvc/CNSHEQUA152.cn.eu.sew ] for the SQL Server service. Error: 0x2af9, state: 61. Administrator should deregister this SPN manually to avoid client authentication errors.
Error 25641:package0.event_file filename参数无效 Error 912:master升级脚本u_tables.sql执行失败,实例无法启动
这是一篇受密码保护的文章,请输入密码进行访问:
广告:
相关文章


