mysql2008无法启动_sql2008服务无法启动的问题。。。

使用的环境为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关闭什么服务导致这个么?还是有配置文件损坏了?

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值