Recovery Model Constants (SQLDMO_RECOVERY_TYPE)
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
Recovery model constants are used to specify the recovery model for a database.
Constant |
Value |
Description |
|---|---|---|
SQLDMORECOVERY_BulkLogged |
1 |
Uses the Bulk-Logged Recovery model. |
SQLDMORECOVERY_Full |
2 |
Uses the Full Recovery model. |
SQLDMORECOVERY_Simple |
0 |
Default. Uses the Simple Recovery model. |
SQLDMORECOVERY_Unknown |
3 |
The recovery model is unknown. |