Log truncation is essential to keep the log from filling. Log truncation deletes inactive virtual log files from the logical
transaction log of a SQL Server database, freeing space in the logical log for reuse by the physical transaction log. If a
transaction log were never truncated, it would eventually fill all the disk space that is allocated to its physical log files.
However, before the log can be truncated, a checkpoint operation must occur. A checkpoint writes the current in-memory
modified pages (known as dirty pages) and transaction log information from memory to disk. When the checkpoint is
performed, the inactive portion of the transaction log is marked as reusable. Thereafter, the inactive portion can be freed by
log truncation.
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment