DatabaseStatus Enumeration
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.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.SqlEnum (in Microsoft.SqlServer.SqlEnum.dll)
Syntax
'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
Members
| Member name | Description | |
|---|---|---|
| AutoClosed | The database has been automatically closed. | |
| EmergencyMode | The database is in emergency mode. | |
| Inaccessible | The database is inaccessible. The server might be switched off or the network connection has been interrupted. | |
| Normal | The database is available. | |
| Offline | The database has been taken offline. | |
| Recovering | The database is going through the recovery process. | |
| RecoveryPending | The database is waiting to go through the recovery process. | |
| Restoring | The database is going through the restore process. | |
| Shutdown | The server on which the database resides has been shut down. | |
| Standby | The database is in standby mode. | |
| 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. |
Remarks
The DatabaseStatus enumeration class is served by the Status property.