SqlDatabaseRecoveryMode Enumeration
Models the database recovery mode for SQL Server.
Namespace: Microsoft.Data.Schema.Sql.SchemaModel
Assembly: Microsoft.Data.Schema.Sql (in Microsoft.Data.Schema.Sql.dll)
Syntax
'Declaration
Public Enumeration SqlDatabaseRecoveryMode
public enum SqlDatabaseRecoveryMode
public enum class SqlDatabaseRecoveryMode
type SqlDatabaseRecoveryMode
public enum SqlDatabaseRecoveryMode
Members
| Member name | Description | |
|---|---|---|
| Unknown | Specifies that the database recovery mode is unknown. | |
| Simple | Specifies that the SIMPLE recovery mode is used.
Simple recovery mode makes no log backups and automatically reclaims log space to keep space requirements small. This eliminates the need to manage the transaction log space. |
|
| BulkLogged | Specifies that the BULK LOGGED recovery mode should be used.
Bulk logged mode requires log backups, is an adjunct of the full recovery model that allows high-performance bulk copy operations, and reduces log space usage by using minimal logging for most bulk operations. |
|
| Full | Specifies that FULL recovery mode should be used.
Full recovery mode requires log backups, makes sure that no work is lost due to a lost or damaged data file. This mode can recover to an arbitrary point in time (for example, before application or user error). |