Share via

DatabaseRecoveryState Enum

  • Reference

Definition

Namespace:
Microsoft.SqlServer.Management.Smo
Assembly:
Microsoft.SqlServer.SmoExtended.dll
Package:
Microsoft.SqlServer.SqlManagementObjects v150.18208.0
Package:
Microsoft.SqlServer.SqlManagementObjects v160.2004021.0

Database recovery state.

public enum DatabaseRecoveryState
type DatabaseRecoveryState = 
Public Enum DatabaseRecoveryState
Inheritance
Enum
DatabaseRecoveryState

Fields

Name Value Description
WithRecovery 0

RECOVERY Leave the database ready to use by rolling back uncommitted transactions. Additional transaction logs cannot be restored.
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.
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