March 16, 2011 at 10:09 am
My SQL Server went down for some reason and I can't get to it from Remote dek top. What should I do? How can I check what's wrong?
... We are ok now, we can to it,but how can I check what happend to the server?
March 16, 2011 at 11:02 am
SQL error log, windows event logs
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 16, 2011 at 11:07 am
Nothing in sql logs
March 16, 2011 at 2:38 pm
You need to check the windows event logs to see why the server crashed - or if the server was shut down and restarted.
If there is nothing in the SQL Server logs - then most likely someone shut down the server or restarted it.
Look in the system event log where the source is USER32 - these events are raised when a user initiates a server shutdown/restart. Focus on the time that you find from the SQL Server logs when SQL Server was last started.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
March 20, 2011 at 11:06 pm
where can i check windows event logs
can you suggest me path...
i think event viewer is windows event logs right can you correct me.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply