TABLE 2: DATABASEPROPERTYEX Possible Output Values
Value Definition
ONLINE Database is available for query
OFFLINE Database was explicitly taken offline
RESTORING SQL Server is restoring the database
RECOVERING Database is recovering and not yet ready for queries
SUSPECT SQL Server can't recover the database