DatabaseRecoveryState Enumeration
Specifies the state of the database restore operation.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.SmoExtended (in Microsoft.SqlServer.SmoExtended.dll)
Syntax
'Declaration
Public Enumeration DatabaseRecoveryState
'Usage
Dim instance As DatabaseRecoveryState
public enum DatabaseRecoveryState
public enum class DatabaseRecoveryState
type DatabaseRecoveryState
public enum DatabaseRecoveryState
Members
| Member name | Description | |
|---|---|---|
| WithNoRecovery | Instructs the restore operation to not rollback any uncommitted transactions for another transaction log backup to be restored later. The database remains in the restoring state after the restore operation. | |
| WithRecovery | Leaves the database ready to use by rolling back uncommitted transactions. Additional transaction logs cannot be restored. | |
| WithStandBy | Rollbacks uncommitted transactions, but saves the rollback actions in a standby file that allows the recovery effects to be reversed. |