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
Comments