Theenumeration is a list of constant values that specify the status of a database, whether it be loading, recovering, or normal, for example. This enumeration has a FlagsAttribute attribute that allows a bitwise combination of its member values.
Assembly: Microsoft.SqlServer.SqlEnum (in Microsoft.SqlServer.SqlEnum.dll)
The database has been automatically closed.
The database is in emergency mode.
The database is inaccessible. The server might be switched off or the network connection has been interrupted.
The database is available.
The database has been taken offline.
The database is going through the recovery process.
The database is waiting to go through the recovery process.
The database is going through the restore process.
The server on which the database resides has been shut down.
The database is in standby mode.
The database has been marked as suspect. You will have to check the data, and the database might have to be restored from a backup.