DatabaseAdapterBase.Status Property
Gets the database status.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
Public ReadOnly Property Status As DatabaseStatus
Get
'Usage
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
Property Value
Type: Microsoft.SqlServer.Management.Smo.DatabaseStatus
The database status.
Remarks
The following table lists the values that are associated with the database status.
Member Name |
The description name. |
|---|---|
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 have to be restored from a backup. |