How to Check the last restart for DB Server
Rédigé par Sozezzo - - Aucun commentairego -- 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