我装了VSTS2008 安装sql server2008 和SP1,但是以启动就出现3个错误.
日志描述如下:
[2009-11-02 18:43:27.33 spid6s Starting up database 'msdb'.
2009-11-02 18:43:28.32 spid6s 84 transactions rolled forward in database 'msdb' (4). This is an informational message only. No user action is required.
2009-11-02 18:43:28.44 spid6s 0 transactions rolled back in database 'msdb' (4). This is an informational message only. No user action is required.
2009-11-02 18:43:28.44 spid6s Recovery is writing a checkpoint in database 'msdb' (4). This is an informational message only. No user action is required.
2009-11-02 18:43:28.72 spid10s Starting up database 'tempdb'.
2009-11-02 18:43:28.80 spid13s The Service Broker protocol transport is disabled or not configured.
2009-11-02 18:43:28.80 spid13s The Database Mirroring protocol transport is disabled or not configured.
2009-11-02 18:43:28.82 spid13s Service Broker manager has started.
2009-11-02 18:43:30.20 spid6s 数据库 'master' 正在将脚本 'sqlagent100_msdb_upgrade.sql' 从级别 0 升级到级别 2。
2009-11-02 18:43:30.20 spid6s ----------------------------------------
2009-11-02 18:43:30.20 spid6s Starting execution of PREINSTMSDB100.SQL
2009-11-02 18:43:30.20 spid6s ----------------------------------------
2009-11-02 18:43:30.52 spid6s Setting database option COMPATIBILITY_LEVEL to 100 for database msdb.
2009-11-02 18:43:30.62 spid6s 配置选项 'allow updates' 已从 1 更改为 1。请运行 RECONFIGURE 语句进行安装。
2009-11-02 18:43:30.62 spid6s Configuration option 'allow updates' changed from 1 to 1. Run the RECONFIGURE statement to install.
2009-11-02 18:43:30.62 spid6s FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
2009-11-02 18:43:32.34 spid6s Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.
2009-11-02 18:43:32.35 spid6s Using 'xpstar.dll' version '2007.100.1600' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
2009-11-02 18:43:32.39 spid6s DBCC TRACEOFF 1717, server process ID (SPID) 6. This is an informational message only; no user action is required.
2009-11-02 18:43:32.39 spid6s DBCC 执行完毕。如果 DBCC 输出了错误信息,请与系统管理员联系。
2009-11-02 18:43:32.40 spid6s
2009-11-02 18:43:32.40 spid6s Creating table temp_sysjobschedules
2009-11-02 18:43:32.68 spid6s
2009-11-02 18:43:32.68 spid6s Alter table sysdownloadlist...
2009-11-02 18:43:32.68 spid6s
2009-11-02 18:43:32.68 spid6s Alter table sysjobhistory...
2009-11-02 18:43:32.69 spid6s
2009-11-02 18:43:32.69 spid6s Alter table systargetservers...
2009-11-02 18:43:32.95 spid6s 配置选项 'allow updates' 已从 1 更改为 0。请运行 RECONFIGURE 语句进行安装。
2009-11-02 18:43:32.95 spid6s Configuration option 'allow updates' changed from 1 to 0. Run the RECONFIGURE statement to install.
2009-11-02 18:43:32.95 spid6s FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
2009-11-02 18:43:32.99 spid6s DMF pre-upgrade steps...
2009-11-02 18:43:33.00 spid6s DC pre-upgrade steps...
2009-11-02 18:43:33.19 spid6s Deleting cached auto-generated T-SQL Data Collection packages from msdb...
2009-11-02 18:43:33.19 spid6s End of DC pre-upgrade steps.
2009-11-02 18:43:33.19 spid6s
2009-11-02 18:43:33.19 spid6s ----------------------------------------
2009-11-02 18:43:33.19 spid6s Execution of PREINSTMSDB100.SQL complete
2009-11-02 18:43:33.19 spid6s ----------------------------------------
2009-11-02 18:43:33.19 spid6s ----------------------------------
2009-11-02 18:43:33.19 spid6s Starting execution of INSTMSDB.SQL
2009-11-02 18:43:33.19 spid6s ----------------------------------
2009-11-02 18:43:33.27 spid6s 配置选项 'allow updates' 已从 0 更改为 1。请运行 RECONFIGURE 语句进行安装。
2009-11-02 18:43:33.27 spid6s Configuration option 'allow updates' changed from 0 to 1. Run the RECONFIGURE statement to install.
2009-11-02 18:43:33.27 spid6s FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
2009-11-02 18:43:33.42 spid6s Checking the size of MSDB...
2009-11-02 18:43:33.45 spid6s 错误: 8966,严重性: 16,状态: 4。
2009-11-02 18:43:33.45 spid6s Unable to read and latch page (1:412488) with latch type SH. UtilDbccVerifyPageId failed.
2009-11-02 18:43:33.45 spid6s 错误: 8946,严重性: 16,状态: 12。
2009-11-02 18:43:33.45 spid6s 表错误: 分配页 (1:412488) 具有无效的 PFS_PAGE 页头值。类型为 0。请检查该页的类型、分配单元 ID 和页 ID。
2009-11-02 18:43:33.45 spid6s 错误: 912,严重性: 21,状态: 2。
2009-11-02 18:43:33.45 spid6s Script level upgrade for database 'master' failed because upgrade step 'sqlagent100_msdb_upgrade.sql' encountered error 3601, state 5, 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.
2009-11-02 18:43:33.45 spid6s 错误: 3417,严重性: 21,状态: 3。
2009-11-02 18:43:33.45 spid6s 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.
2009-11-02 18:43:33.45 spid6s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
[/code]
系统日志描述为:
错误 2009/11/2 18:43:33 MSSQLSERVER 8966 服务器
原因: 无法使用闩锁类型 SH 读取并闩锁页 (1:412488)。UtilDbccVerifyPageId 失败。
错误 2009/11/2 18:43:33 MSSQLSERVER 912 服务器
原因:由于升级步骤 'sqlagent100_msdb_upgrade.sql' 遇到错误 3601(状态 5,严重性 25),因此数据库 'master' 的脚本级别升级失败。这是一种错误情况,可能会妨碍正常操作,且数据库将脱机。如果在 'master' 数据库升级过程中发生该错误,将阻止整个 SQL Server 实例启动。请在以前的错误日志条目中检查相关错误,采取相应的更正措施,然后重新启动数据库,以便完成脚本升级步骤。
错误 2009/11/2 18:43:33 MSSQLSERVER 3417 服务器
原因:无法恢复 master 数据库。SQL Server 无法运行。请利用完整备份还原 master 数据库,修复它,或者重新生成它。有关如何重新生成 master 数据库的详细信息,请参阅 SQL Server 联机丛书。
按照最后提示我恢复了MASTER数据库但是还是出现上面的错误,好像还是不行.
windows7下sql2008升级SP1后MAster无法更新升级,阻止服务启动
答案:1 悬赏:70 手机版
解决时间 2021-05-08 02:47
- 提问者网友:山高云阔
- 2021-05-07 10:40
最佳答案
- 五星知识达人网友:摆渡翁
- 2021-05-07 10:52
数据库什么版本啊,也打sp1试试!
我要举报
如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
点此我要举报以上问答信息
大家都在看
推荐资讯