Home All Groups Group Topic Archive Search About
Author
14 Jul 2005 6:05 PM
Britney
how to find out when was last time the sql server was down?

Author
14 Jul 2005 6:31 PM
Aaron Bertrand [SQL Server MVP]
> how to find out when was last time the sql server was down?

You can find out the last time the service started:

SELECT MIN(login_time) FROM Master..sysprocesses

If you need to know how long it was down, I think you'll have to either
parse the SQL Server log or look at the system's event viewer...

AddThis Social Bookmark Button