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