3 days back, a support engineer notified us that all the services of 2 Database Servers at our data center had Mysteriously Shutdown. and they had to restart them manually. well, we had a look in the Error Logs, SQL Server Logs and even Event Logs. but couldn't
find anything strongly suspicious. the 2 servers had shutdown almost at the same time ( apprix. 2 mins difference between the shutdown times). yesterday, there was another server with the same symptoms.
here are the facts i found. Date : 4/12/2011
Event Log - Application Log
8:50:00 AM - The MS DTC service is stopping.
8:50:00 AM - The connection has been lost with Microsoft Distributed Transaction Coordinator (MS DTC).
8:50:02 AM - Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
8:50:02 AM - Configuration option 'Agent XPs' changed from 1 to 0. Run the RECONFIGURE statement to install.
8:50:03 AM - SQLServerAgent service successfully stopped.
8:50:04 AM - Service Broker manager has shut down.
8:50:04 AM - 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.
8:50:04 AM - SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action
View Complete Post