DbStatus
SELECT name, database_id, state_desc, recovery_model_desc
FROM SYS.DATABASES where state_desc <> ‘ONLINE’

Uptime
Select CONVERT(CHAR(25),login_time,100), CONVERT(CHAR(25), DATEDIFF(DAY, login_time, GETDATE()))
FROM master..sysprocesses
WHERE spid = 1… 288 more words