SQL-DMO
Recovery Model Constants (SQLDMO_RECOVERY_TYPE)
Recovery Model constants are used to specify the recovery model for a database.
| Constant | Value | Description |
|---|---|---|
| SQLDMORECOVERY_BulkLogged | 1 | Use the Bulk-Logged Recovery model. |
| SQLDMORECOVERY_Full | 2 | Use the Full Recovery model. |
| SQLDMORECOVERY_Simple | 0 | Default. Use the Simple Recovery model. |
| SQLDMORECOVERY_Unknown | 3 | Recovery model is unknown. |