> 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...
