As a routine DBA activity I was analyzing sp_readerrorlog this morning and surprised to see that SQL Server has restarted early this morning.
Here are few different ways that you can make use of to tell when SQL Server was last restarted.
Method 1:
sp_readerrorlog 0,1,'Copyright (c)'
Method 2:
SELECT sqlserver_start_time FROM sys.dm_os_sys_info
sqlserver_start_time
———————–
2013-11-26 01:16:10.757
(1 row(s) affected)
Method 3:
SELECT login_time FROM sys.dm_exec_sessions WHERE session_id = 1
login_time
———————–
2013-11-26 01:16:24.127
(1 row(s) affected)
Method 4:
SELECT create_date FROM sys.databases WHERE name = 'tempdb'
create_date
———————–
2013-11-26 01:16:13.023
(1 row(s) affected)
Method 5:
Right click on the server name in SSMS and select Reports > Standard Reports > Server Dashboard and you will get a report similar to below report.
Method 6:
start -> run -> eventvwr
Chose Windows log -> Application
Open filter and enter Event Sources (MSSQLSERVER) and Event Id (17163)
Here is the output of above filter.
Here are a few different ways that you can tell when Windows last rebooted.
Method 1:
Start Task Manager->Performance
Screen below gives you total up time since last restart.
Method 2:
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.
Here is the output of above filter.
Hope this helps!
sqlerrors 