TruncateLog Property (Backup)
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.
The TruncateLog property controls log file processing for Backup and BulkCopy objects.
Records referencing committed transactions are removed. The transaction log is not backed up.
The transaction log is backed up. Records referencing committed transactions are not removed, providing a point-in-time image of the log.
The transaction log is backed up. Records referencing committed transactions are removed.
For Microsoft SQL Server, transaction log backup can perform two distinct database administration tasks:
Log backup can be part of a backup strategy allowing incremental recovery to a failure point.
Log backup can remove log records referencing committed transactions, freeing space in a log of fixed size or allowing an autoresizing log to shrink.
When using the Backup object to perform administrative maintenance of a database log, set the TruncateLog property to SQLDMOBackup_Log_Truncate or SQLDMOBackup_Log_NoLog.