-
Un-expected SQL Server restart
One of the clustered SQL Server was "restarted" (not failover) yesterday mysteriously.
We only know that it's something to do with MSDTC. Here are the log entries
---------------------------------------------------------
Date 12/11/2007 3:14:02 PM
Log SQL Server (Archive #1 - 12/11/2007 3:15:00 PM)
Source Server
Message
The connection has been lost with Microsoft Distributed Transaction Coordinator (MS DTC). Recovery of any in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC) will begin once the connection is re-established. This is an informational message only. No user action is required.
---------------------------------------------------------
Date 12/11/2007 3:15:30 PM
Log SQL Server (Archive #1 - 12/11/2007 3:15:00 PM)
Source spid53
Message
Configuration option 'Agent XPs' changed from 1 to 0. Run the RECONFIGURE statement to install.
---------------------------------------------------------
Date 12/11/2007 3:15:44 PM
Log SQL Server (Archive #1 - 12/11/2007 3:15:00 PM)
Source spid35s
Message
Service Broker manager has shut down.
---------------------------------------------------------
Date 12/11/2007 3:15:46 PM
Log SQL Server (Archive #1 - 12/11/2007 3:15:00 PM)
Source spid11s
Message
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.
---------------------------------------------------------
Date 12/11/2007 3:15:46 PM
Log SQL Server (Archive #1 - 12/11/2007 3:15:00 PM)
Source spid11s
Message
SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
---------------------------------------------------------
----Then restart happened.
Thanks in advance.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|