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.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.SqlEnum (in microsoft.sqlserver.sqlenum.dll)
Syntax
'Deklaracja
<FlagsAttribute> _
Public Enumeration DatabaseStatus
[FlagsAttribute]
public enum DatabaseStatus
[FlagsAttribute]
public enum class DatabaseStatus
/** @attribute FlagsAttribute() */
public enum DatabaseStatus
FlagsAttribute
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. |
Platforms
Development Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server.
Target Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server.