☰

MSSQL 实例关闭错误 17054

tag-icon • tag-icon sql-server-2008 sql-server
MSSQL 实例关闭错误 17054

我的一些 mssql 实例在一段时间后关闭。启用日志记录后，我能够收到有关服务关闭原因的错误消息：

2010-06-23 15:49:53.34 Server      Server resumed execution after being idle 33570 seconds: user activity awakened the server. This is an informational message only. No user action is required.
2010-06-24 01:04:48.84 spid1s      Server resumed execution after being idle 32039 seconds. Reason: timer event.
2010-06-24 03:14:42.14 Server      SQL Server is terminating because of a system shutdown. This is an informational message only. No user action is required.
2010-06-24 03:15:56.35 spid7s      Server resumed execution after being idle 6949 seconds: user activity awakened the server. This is an informational message only. No user action is required.
2010-06-24 03:15:59.01 spid7s      Fehler: 17054, Schweregrad: 16, Status: 1.
2010-06-24 03:15:59.01 spid7s      The current event was not reported to the Windows Events log. Operating system error = (null). You may need to clear the Windows Events log if it is full.

我似乎无法通过 Google 查找错误 17054 的含义？这是什么意思？

我如何防止实例服务关闭？问题是，尽管服务的启动类型设置为自动，但发生此类错误后服务不会自动启动。
我可以编写另一个服务来监视实例服务，并在实例服务关闭时简单地启动它们。但我宁愿修复 MSSQL Server 的问题

答案1

听起来服务器正在重新启动，可能是因为自动更新？显示错误 17054 是因为 SQL Server 尝试将事件写入 Windows 事件日志，但失败了，可能与重新启动有关。

答案2

检查以确保您的 SQL Browser 服务也在运行。这是我的实例的问题。

相关内容