急，高分 SQL SERVER 2005 定时挂掉问题

[kjeny2002]

错误日志
SQL Server is terminating because of a system shutdown. This is an informational message only. No user action is required.
Service Broker manager has shut down.
Error: 17054, Severity: 16, State: 1.
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.
SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
The SQL Network Interface library could not deregister the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b. Administrator should deregister this SPN manually to avoid client authentication errors.


Microsoft SQL Server Management Studio 9.00.1399.00
Microsoft Analysis Services 客户端工具 2005.090.1399.00
Microsoft 数据访问组件 (MDAC) 2000.086.3959.00 (srv03_sp2_rtm.070216-1710)
Microsoft MSXML 2.6 3.0 6.0
Microsoft Internet Explorer 7.0.5730.13
Microsoft .NET Framework 2.0.50727.42
操作系统 5.2.3790

急，谁能解答一下哇

[dawugui]

我只听说过定时做某个作业,第一次听说定时让服务死掉.难道你有个作业定时让SQL服务死掉?

[快乐_石头]

because of a system shutdown
非法关机了吧

[dawugui]

很同情你,爱莫能助,友情帮顶.

[htl258_Tony]

[Quote=引用 3 楼 dawugui 的回复:]
很同情你,爱莫能助,友情帮顶.
[/Quote]..

[kjeny2002]

定时挂了后又自己重启了。


另外。我开启了SQL SERVER AGENT服务来做备份。。

[kjeny2002]

http://topic.csdn.net/u/20081028/16/30d62910-218f-4e13-bf57-dbf83fecef5a.html?1202811260


这里也有人在问。但好像还没有解决问题

[zzxap]

You may need to clear the Windows Events log if it is full.

日志满了，清理日志吧

[dawugui]

[Quote=引用 5 楼 kjeny2002 的回复:]
定时挂了后又自己重启了。


另外。我开启了SQL SERVER AGENT服务来做备份。。
[/Quote]
那就是你的某个代码中有定时停止SQL然后又重启动SQL.

你查查你的代码中是否有这些语句.

用命令行启动停止暂停SQL SERVER

启动：net start mssqlserver
暂停：net pause mssqlserver
重新启动暂停的SQL SERVER：net continue mssqlserver
停止：net stop mssqlserver

[zzxap]

SQL Server is terminating because of a system shutdown. This is an informational message only. No user action is required.
Service Broker manager has shut down.
Error: 17054, Severity: 16, State: 1.
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.
SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
The SQL Network Interface library could not deregister the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b. Administrator should deregister this SPN manually to avoid client authentication errors.

这已经说得很明白了

[kjeny2002]

服务器和SQL SERVER都是新装的。。才用了一星期。。这二天开始报这个问题了。

[zzxap]

http://www.microsoft.com/downloads/details.aspx?displaylang=zh-cn&FamilyID=d07219b2-1e23-49c8-8f0c-63fa18f26d3a
打补丁

[zzxap]

http://www.microsoft.com/downloads/details.aspx?FamilyID=5d1c98bc-c594-4403-8ec9-c250331d56fc&DisplayLang=zh-tw

[kjeny2002]

请问是否打完补丁就能解决这个问题、。

现在出到SP3了。

[kjeny2002]

SQL Server is terminating because of a system shutdown.

[130] 由于 Windows 关闭，SQLSERVERAGENT 正在停止...
[359] 本地主机服务器未运行
[098] SQLServerAgent 已终止(一般)


系统重启引起的？
系统没有去手动重启过。难道是自动重启？

[kjeny2002]

终于发现问题了。。。

服务器开了自动更新

更新后完就自动重启了。。。

所以问题是由于服务器自动重启引起的。



谢谢各位

[zzxap]

晕

[漫欣]

遇到和你一模一样问题，也是半夜3点自动启动重启，还以为是我程序的原因，找了好久，一直搞不定。。还真是自动更新后时间设置在3点重启。。。