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_Truncate 0 Transaction log is backed up. Records referencing committed transactions are removed.
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_NoLog 2 Records referencing committed transactions are removed. Transaction log is not backed up.
SQLDMOBackup_Log_Truncateonly 3 SQLDMOBackup_Log_
NoLog.
SQLDMOBackup_Log_NoOption 4 SQLDMOBackup_Log_
Truncate.

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.