DatabaseRecoveryState Enumeration
Specifies the state of the database restore operation.
Assembly: Microsoft.SqlServer.SmoExtended (in Microsoft.SqlServer.SmoExtended.dll)
| 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. |
Show: