SQL-DMO
Transaction Log Backup Constants (SQLDMO_BACKUP_LOG_TYPE)
Transaction log backup constants configure execution when using the SQL-DMO Backup object to back up only the transaction log of a selected database.
| Constant | Value | Description |
|---|---|---|
| SQLDMOBackup_Log_NoLog | 2 | Records referencing committed transactions are removed. Transaction log is not backed up. |
| SQLDMOBackup_Log_NoOption | 4 | SQLDMOBackup_Log_ Truncate. |
| SQLDMOBackup_Log_NoTruncate | 1 | Transaction log is backed up. Records referencing committed transactions are not removed, providing a point-in-time image of the log. |
| SQLDMOBackup_Log_Truncate | 0 | Transaction log is backed up. Records referencing committed transactions are removed. |
| SQLDMOBackup_Log_Truncateonly | 3 | SQLDMOBackup_Log_NoLog. |