[스크랩] MSSQL 인스턴스 갑자기 다운

 

http://blog.skybyte.com/blog/network-helpdesk/microsoft-sql-server-shutting-down-every-night-microsoft-sql-upgrade

 

I ran across an issue on a client's SQL Server 2005 Express instance. The problem was that at 4:01am every morning the SQL server would just shutdown with the event messages of

1. Service Broker manager has shut down.
2. SQL Server is terminating in response to a 'stop' request from Service Control Manager. This is an informational message only. No user action is required.
3. SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.

After a week of trying to narrow down the issue I found that it was Windows Update automatically trying to install the SP4 update for MSSQL 2005 Express and failing. This failure would cause the SQL server to shutdown for the update, but not come back up. This shutdown was affecting programs like Blackberry Enterprise Server and also BackupExec which would then crash and need to have their services restarted after bringing the SQL instances back online. The fix for this issue was merely to disable the update and also for preventing future issues I disabled the automatic installation of updates.

This issue could relate to Microsoft SQL Server Upgrades and Blackberry Enterprise Server Support.

 

 

 

 

 

 

 

 

이런 식으로 발생함..

 

 

 

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/ffc4758f-0e4b-4546-91e8-56b75d051bdc/sql-server-service-broker-manager-shut-down-by-itself?forum=sqldatabaseengine

 

다른 답변 다 볼 필요 없고,

 

If we go through system log in Eventviewer we will find that service control manager will send the stop command to sqlserver agent and sqlserver engine.
This is acutally because of some windows update which inturn will affect Microsoft SQL Server.
Before that Service control Manager command, if checked we will find windows update agent category event. That event is for the security update of Microsoft SQL Server.
Because of it SCM will issue stop command to Microsoft SQL Server Agent and Engine.
Hope my explanation is usefull... 

 

 

이 내용만 보면 됨.

 

 

그래서 자동업데이트를 아예 Turn Off 시켜 버림.