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)
Assembly: Microsoft.SqlServer.SqlEnum (in microsoft.sqlserver.sqlenum.dll)
| 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 become 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. The data will need to be checked and the database might need to be restored from a backup. |
The DatabaseStatus enumeration class is served by the Status property.
This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.
Development Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.Target Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.
