August 25, 2009 at 2:32 pm
one of the SQL Server was down and i didnt realise, when i checked for the reason i find this in the event log
SQL Server is terminating because of a system shutdown. This is an informational message only. No user action is required.
What does this mean, the computer was still running after this mesage genrated in log, what might be hte exact reason for sql server going down.
thanks
August 25, 2009 at 2:34 pm
did you log in to the server console to see if some process was causing the server not to reboot? See if anyone else is RDP'd in to the server.
August 25, 2009 at 3:20 pm
did you look in the last sql log?
probably not much there, but you could see if the SHUTDOWN command was issued
~BOT
Craig Outcalt
August 25, 2009 at 3:29 pm
SQL Server is terminating because of a system shutdown. This is an informational message only. No user action is required.
Around the time you found this in your logs ..... you could also find a system log entry at OS event log where the login that initiated the shutdown would be there ....
and as mentioned earlier in this thread .... there could be a process thats stopping the system to shutdown .... but SQL Server as a service was stopped
-------------------------------------------------
-Amit
Give a man a fish and he'll ask for a lemon. Teach a man to fish and he wont get paged on weekends !! :w00t: - desparately trying to fish [/size]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply