On SQL Server 2008, how to find out when was any database offline/online?

Question

I have to include one report in my application showing offline/online activity of few databases on SQL Server 2008. Could you please suggest how can I collect the same information from sql server?

Answer 1

You can also use below query to check database status.

SELECT Name, state_desc FROM sys.databases

Answer 2

SELECT DATABASEPROPERTYEX('YOURDATABASE', 'Status')
DatabaseStatus_DATABASEPROPERTYEX
GO

SELECT state_desc DatabaseStatus_sysDatabase
FROM sys.databases
WHERE name = 'YOURDATABASE'
GO

This will tell you the status of the database.