SQL server服务启动不了

[devilspie2]

我的数据库是sql 2008 之前用ssms登录本地数据库是没有问题的 现在不能登录了 我看了下 sql server那个服务启动不了
以下是日志 高手帮忙解决以下吧！！

2010-08-25 10:20:24.65 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)

2010-08-25 10:20:24.65 Server (c) 2005 Microsoft Corporation.
2010-08-25 10:20:24.65 Server All rights reserved.
2010-08-25 10:20:24.65 Server Server process ID is 5056.
2010-08-25 10:20:24.65 Server Authentication mode is MIXED.
2010-08-25 10:20:24.65 Server Logging SQL Server messages in file 'E:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
2010-08-25 10:20:24.65 Server This instance of SQL Server last reported using a process ID of 4884 at 2010-8-25 10:15:35 (local) 2010-8-25 2:15:35 (UTC). This is an informational message only; no user action is required.
2010-08-25 10:20:24.65 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
2010-08-25 10:20:24.67 服务器 SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2010-08-25 10:20:24.67 服务器 Detected 1 CPUs. This is an informational message; no user action is required.
2010-08-25 10:20:25.23 服务器 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.
2010-08-25 10:20:25.34 服务器 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.
2010-08-25 10:20:25.39 spid7s Starting up database 'master'.
2010-08-25 10:20:25.43 spid7s 错误: 9003，严重性: 20，状态: 1。
2010-08-25 10:20:25.43 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.
2010-08-25 10:20:25.43 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.

[Zoezs]

查看下系统日志。
貌似是master库坏掉了。
不可以试试，先把data文件夹下的master.ldf的文件拷出来，再建一个空的。如果这样不行，那么等喜下问问大叔。

[zheninchangjiang]

没有备份,就拿出安装程序安装,安装程序可以重建master,
看了一下,2008的版倒不如2000,没有rebuildm程序了

[hao1hao2hao3]

管理工具中的事件查看器中的系统菜单有什么红色的提示？

[obuntu]

2010-08-25 10:20:25.43 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数据库的全备吗？
如果有的话，恢复一个。

[Austindatabases]

还原master数据库（用户信息）
master数据库存储了登录SQL Server的用户名及密码、权限等信息，还原此数据库必须以独占方式启动SQL Server，方法是：
1.在 SQL Server 配置管理器中，单击“SQL Server 服务”。
2.在右窗格中，右键单击 SQL Server (<实例名>)，再单击“属性”。
3.在“高级”选项卡的“启动参数”框中，键入以分号 (;) 分隔的参数。
例如，若要以单用户模式启动，请在现有启动选项之前插入 -m;，然后重新启动数据库。
单击“确定”。
4.重新启动数据库引擎。
5.打开“开始”－“运行”，输入：sqlcmd （打开SQLCMD工具）
6.输入如下脚本：
1> RESTORE DATABASE master FROM DISK = 'Z:\存储master完整备份的文件地址\master.bak';
2> GO
7.结束单用户模式的使用之后，若要以正常的多用户模式重新启动服务器实例，必须先从“启动参数”框中删除 -m;，重新启动SQL Server服务。


本文来自CSDN博客，转载请标明出处：http://blog.csdn.net/jia_guijun/archive/2008/09/02/2865752.aspx