sqlserver服务启动不了，求高手解决

[devilspie2]

我的是sqlserver2008，以前没事，现在服务启动不了了，试过各种网上说的办法了，都不行，高手说下具体怎么解决把，错误日志如下：
2011-04-13 17:12:57.90 Server Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)
Jul 9 2008 14:43:34
Copyright (c) 1988-2008 Microsoft Corporation
Enterprise Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)

2011-04-13 17:12:57.96 Server (c) 2005 Microsoft Corporation.
2011-04-13 17:12:57.96 Server All rights reserved.
2011-04-13 17:12:57.96 Server Server process ID is 5220.
2011-04-13 17:12:57.96 Server Authentication mode is MIXED.
2011-04-13 17:12:57.96 Server Logging SQL Server messages in file 'E:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
2011-04-13 17:12:57.96 Server This instance of SQL Server last reported using a process ID of 2076 at 2006-1-1 0:02:00 (local) 2005-12-31 16:02:00 (UTC). This is an informational message only; no user action is required.
2011-04-13 17:12:58.00 Server Registry startup parameters:
-d E:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\master.mdf
-e E:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG
-l E:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
2011-04-13 17:12:58.20 服务器 SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2011-04-13 17:12:58.20 服务器 Detected 1 CPUs. This is an informational message; no user action is required.
2011-04-13 17:12:58.71 服务器 Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2011-04-13 17:12:58.96 服务器 Node configuration: node 0: CPU mask: 0x00000001 Active CPU mask: 0x00000001. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2011-04-13 17:13:00.42 spid7s Starting up database 'master'.
2011-04-13 17:13:00.79 spid7s 错误: 9003，严重性: 20，状态: 1。
2011-04-13 17:13:00.79 spid7s The log scan number (192:360:1) passed to log scan in database 'master' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup.
2011-04-13 17:13:00.89 spid7s 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.

[快溜]

我能看懂数字和CPU等关键词。

[orochi_gao]

master数据库无法还原,看看物理文件有异常没,到其他实例上还原其他名字数据库试试看

[--小F--]

出现这样的问题 最好是重新安装

[rucypli]

看ERRORLOG

估计需要还原master库

[obuntu]

2011-04-13 17:13:00.79 spid7s The log scan number (192:360:1) passed to log scan in database 'master' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup.

提示很清楚了，master的发生损坏，需要恢复master数据库。有备份吗，有的话，恢复个master数据库吧。

还原 master 数据库
在单用户模式下启动服务器实例。

使用 RESTORE DATABASE 语句还原 master 的完整数据库备份。在单用户模式下，建议您在 sqlcmd 实用工具中输入 RESTORE DATABASE 语句。

C:\> sqlcmd
1> RESTORE DATABASE master FROM DISK = 'Z:\SQLServerBackups\master.bak';
2> GO

联机丛书上有master还原的说明的。

如果没有备份，就重新安装个吧，再把数据库附加。

[devilspie2]

[Quote=引用 4 楼 rucypli 的回复:]
看ERRORLOG

估计需要还原master库
[/Quote]

问题是我现在服务都启不起来，C:\> sqlcmd 根本登录进不去的啊

[nevergu]

最好还是重装吧。花的时间还少些。。。