Transaction Log Truncation

If log records were never deleted from the transaction log, it would eventually fill all the disk space that is available to the physical log files. Log truncation automatically frees space in the logical log for reuse by the transaction log. Except when delayed for some reason, log truncation occurs automatically as follows: Under the …