1
 2go
 3-- Last SQL Server instance restart.
 4SELECT sqlserver_start_time FROM sys.dm_os_sys_info;
 5go
 6-- Last SQL Agent Server restart.
 7SELECT login_time as 'sqlserver_agent_start_time' FROM master.dbo.sysprocesses WHERE program_name = N'SQLAgent - Generic Refresher';
 8go
 9-- Last DB windows server restart.
10exec xp_cmdshell 'systeminfo | find "Time:"';
11go