Export (0) Print
Expand All
Expand Minimize

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)

public enum DatabaseStatus

Member nameDescription
AutoClosedThe database has been automatically closed.
EmergencyModeThe database is in emergency mode.
InaccessibleThe database is inaccessible. The server might be switched off or the network connection has been interrupted.
NormalThe database is available.
OfflineThe database has been taken offline.
RecoveringThe database is going through the recovery process.
RecoveryPendingThe database is waiting to go through the recovery process.
RestoringThe database is going through the restore process.
ShutdownThe server on which the database resides has been shut down.
StandbyThe database is in standby mode.
SuspectThe database has been marked as suspect. You will have to check the data, and the database might have to be restored from a backup.

The DatabaseStatus enumeration class is served by the Status property.

Community Additions

ADD
Show:
© 2014 Microsoft