使用的环境为windows2008server+sql2008,昨天服务器运行过程中停了一次电,来电后重新打开服务器就不能连接到本地数据库了,去配置管理器里面发现sql的服务未启动,手动启动失败。。。但是本身windows和sql都没有报错。。。然后sql去连接别的服务器上的sql是成功的。。。查了下日志报错如下
2009-04-17 08:40:11.99 Server Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\BKUPEXEC ].
2009-04-17 08:40:11.99 Server Server named pipe provider is ready to accept connection on [ \\.\pipe\MSSQL$BKUPEXEC\sql\query ].
2009-04-17 08:40:11.99 Server Dedicated administrator connection support was not started because it is not available on this edition of SQL Server. This is an informational message only. No user action is required.
2009-04-17 08:40:12.00 Server The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b, state: 3. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.
2009-04-17 08:40:12.00 Server SQL Server is now ready for client connections. This is an informational message; no user action is required.
2009-04-17 08:44:10.62 Server The time stamp counter of CPU on scheduler id 1 is not synchronized with other CPUs.
2009-04-17 08:48:10.99 Server The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs.
2009-04-17 08:52:48.59 Server SQL Server is terminating because of a system shutdown. This is an informational message only. No user action is required.
2009-04-17 08:52:48.69 spid11s Service Broker manager has shut down.
2009-04-17 08:52:48.69 spid11s Error: 17054, Severity: 16, State: 1.
2009-04-17 08:52:48.69 spid11s The current event was not reported to the Windows Events log. Operating system error = 1717(接口未知。). You may need to clear the Windows Events log if it is full.
2009-04-17 08:52:48.72 spid4s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
非正常断电会使windows关闭什么服务导致这个么?还是有配置文件损坏了?