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)

public enum DatabaseStatus
/** @attribute FlagsAttribute() */ 
public enum DatabaseStatus
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 become 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. 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

Community Additions