Export (0) Print
Expand All

Managing the Transaction Log

This topic discusses the routine management of transaction log space to prevent the transaction log from becoming full.

Log truncation, which is automatic under the simple recovery model, is essential to keep the log from filling. The truncation process reduces the size of the logical log file by marking as inactive the virtual log files that do not hold any part of the logical log. In some cases, however, physically shrinking or expanding the physical log file is useful.

NoteNote

A small autogrowth increment on a log file can also reduce performance. The file growth increment on a log file should be sufficiently large to avoid frequent expansion. The default growth increment of 10 percent is generally suitable. For information on changing the file-growth property on a log file, see ALTER DATABASE (Transact-SQL).

Transaction Log Truncation

Contains information about log truncation.

Managing the Size of the Transaction Log File

Contains information about monitoring the size of the transaction log, shrinking the transaction log, adding or removing a transaction log file, and optimizing the tempdb transaction log growth rate.

Factors That Can Delay Log Truncation

Describes factors that can delay log truncation.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft