Any suggestions? Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
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.

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.SqlEnum (in Microsoft.SqlServer.SqlEnum.dll)

[FlagsAttribute]
public enum DatabaseStatus

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

The DatabaseStatus enumeration class is served by the Status property.

Return to top
Show:
© 2016 Microsoft