Hi Dears i received request from the developers by the Staging DB was down yesterday evening, between 6:00 PM to 9:00 PM, can you please advice at this time to do Scientific investigation and troubleshooting so at this time you should check 2 point :
- Last SQL Server instance restart.
- Last DB server (windows services ) restart.
Last SQL Server Restart :
we can check it easily and by the Easiest ways (SQL Query)
start -> run -> eventvwr
Choose: Windows Log – > System
Open filter and following Event Id’s
6005 to see when the Event Log service was started. It gives the message “The Event log service was started”.
6006 to see when there was a clean shutdown. It gives the message “The Event log service was stopped”.
6008 to see when there was a dirty shutdown. It gives the message “The previous system shutdown at time on date was unexpected”.
6009 is logged during every boot.
Run the following from a command prompt:
systeminfo | find “Time:”
The output will look something like this:
System Boot Time: 11/12/2013, 1:23:45 AM