OS Reboot Check
Execute any command in command prompt from below listings:
- net stats srv | find "Statistics since"
- or
- systeminfo | find "System Up Time"
- or
- systeminfo | find "System Boot Time"
SQL Reboot Check
Execute any command in SSMS from below listings:
- sp_readerrorlog 0,1,'Copyright (c)'
- or
- SELECT sqlserver_start_time FROM sys.dm_os_sys_info;
- or
- SELECT login_time FROM sys.dm_exec_sessions WHERE session_id = 1;
- or
- select start_time from sys.traces where is_default = 1
- or
- SELECT create_date FROM sys.databases WHERE name = 'tempdb'
Regards,
Yashwant Vishwakarma