DatabaseRecoveryState Enum

Definition

Database recovery state.

public enum DatabaseRecoveryState
type DatabaseRecoveryState = 
Public Enum DatabaseRecoveryState
Inheritance
DatabaseRecoveryState

Fields

WithNoRecovery 1

NORECOVERY Instructs the restore operation to not roll back any uncommitted transactions for another transaction log backup to be restored later. The database remains in the restoring state after the restore operation.

WithRecovery 0

RECOVERY Leave the database ready to use by rolling back uncommitted transactions. Additional transaction logs cannot be restored.

WithStandBy 2

STANDBY Undo uncommitted transactions, but save the undo actions in a standby file that allows the recovery effects to be reversed.

Applies to