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

Remarks

The DatabaseStatus enumeration class is served by the Status property.