April 15, 2010 at 11:13 am
I am expreincing since a while, unexpectedly sql server machine gets rebooted byitself and when i look at the logs or events i dont see any such information but i see that " DB has been started" message for all sql databases.
what is the best way to find details about the computer reboot ?
April 15, 2010 at 11:59 am
What events immedaitely preceed the restart in the event log- both system and application event logs?
What OS is this 2000, 2003?
What SQL Server version and service pack are you running?
April 15, 2010 at 12:06 pm
Also- you can look at the trace file to see what event immediately precedes the restart if you are convinced it is SQL Server related.
I remember a similar problem a few years ago with a system that rebooted itself and left no clue in the logs. Turned out there was a memory leak in some process that was application related (installed on the same server as the database).
At the OS level, you can specify system properties telling what should occur in case of system failure... I believe it's "startup and recovery options"... you can specify "write and event to the event log", "send adminsitrative alert", "generate memory dump".
you can then attempt to get information from the memory dump to let you know what process cause the problem.
Often that kind of this is attributable to a hardware failure.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply