Problem:
I received a request
from one of the developer saying that, the Staging DB was down yesterday
evening, between 6:00 PM to 8:00 PM.
Due to this, he
was not able to meet his deadline.
Solution:
Since it was
staging server, we do not configure automate mail alert for service restart.
So, to answer such
question, I have checked below things.
1. Last SQL Server instance restart.
2. Last DB server (windows services)
restart.
HOW TO CHECK ?
SQL Server Restart:
We can check it
easily and by the Easiest ways (SQL Query)
SELECT
sqlserver_start_time FROM sys.dm_os_sys_info
SELECT 'Statistics
since: ' + CAST(sqlserver_start_time AS
VARCHAR) FROM sys.dm_os_sys_info
OR
EXEC SP_HELPDB 'Tempdb'
