Partilhar via

  • Artigo

Propriedade Status

Gets the database status.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (em Microsoft.SqlServer.Smo.dll)

Sintaxe

'Declaração
Public ReadOnly Property Status As DatabaseStatus
    Get
'Uso
Dim instance As DatabaseAdapterBase
Dim value As DatabaseStatus

value = instance.Status

public DatabaseStatus Status { get; }

public:
virtual property DatabaseStatus Status {
    DatabaseStatus get () sealed;
}

abstract Status : DatabaseStatus
override Status : DatabaseStatus

final function get Status () : DatabaseStatus

Comentários

The following tables lists the values that are associated with the database status:

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.