How to Check the last restart for DB Server

Rédigé par Sozezzo - - Aucun commentaire


go
-- Last SQL Server instance restart.
SELECT sqlserver_start_time FROM sys.dm_os_sys_info;
go
-- Last SQL Agent Server restart.
SELECT login_time as 'sqlserver_agent_start_time' FROM master.dbo.sysprocesses WHERE program_name = N'SQLAgent - Generic Refresher';
go
-- Last DB windows server restart.
exec xp_cmdshell 'systeminfo | find "Time:"';
go

Les commentaires sont fermés.