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.

Espace de noms: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.SqlEnum (in microsoft.sqlserver.sqlenum.dll)

Syntaxe

'Déclaration
<FlagsAttribute> _
Public Enumeration DatabaseStatus
[FlagsAttribute] 
public enum DatabaseStatus
[FlagsAttribute] 
public enum class DatabaseStatus
/** @attribute FlagsAttribute() */ 
public enum DatabaseStatus
FlagsAttribute 
public enum DatabaseStatus

Members

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.

Notes

The DatabaseStatus enumeration class is served by the Status property.

Cet espace de noms, cette classe ou ce membre est pris en charge uniquement par la version 2.0 de Microsoft .NET Framework.

Plateformes

Plateformes de développement

Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.

Plateformes cibles

Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.

Voir aussi

Référence

Microsoft.SqlServer.Management.Smo Namespace