The DatabaseStatus 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)
'Declaration <FlagsAttribute> _ Public Enumeration DatabaseStatus 'Usage Dim instance As DatabaseStatus
[FlagsAttribute] public enum DatabaseStatus
[FlagsAttribute] public enum class DatabaseStatus
[<FlagsAttribute>] type DatabaseStatus
public enum DatabaseStatus
|Normal||The database is available.|
|Restoring||The database is going through the restore process.|
|RecoveryPending||The database is waiting to go through the recovery process.|
|Recovering||The database is going through the recovery process.|
|Suspect||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.|
|Offline||The database has been taken offline.|
|Standby||The database is in standby mode.|
|Shutdown||The server on which the database resides has been shut down.|
|EmergencyMode||The database is in emergency mode.|
|AutoClosed||The database has been automatically closed.|
|Inaccessible||The database is inaccessible. The server might be switched off or the network connection has been interrupted.|
The DatabaseStatus enumeration class is served by the Status property.