Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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. |