Transaction Log Backup Constants (SQLDMO_BACKUP_LOG_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.
Transaction log backup constants configure execution when the SQL Distributed Management Objects (SQL-DMO) Backup object is used to back up only the transaction log of a selected database.
Constant |
Value |
Description |
|---|---|---|
SQLDMOBackup_Log_NoLog |
2 |
Records that reference committed transactions are removed. The transaction log is not backed up. |
SQLDMOBackup_Log_NoOption |
4 |
SQLDMOBackup_Log_Truncate. |
SQLDMOBackup_Log_NoTruncate |
1 |
The transaction log is backed up. Records that reference committed transactions are not removed, providing a point-in-time image of the log. |
SQLDMOBackup_Log_Truncate |
0 |
The transaction log is backed up. Records that reference committed transactions are removed. |
SQLDMOBackup_Log_Truncateonly |
3 |
SQLDMOBackup_Log_NoLog. |