SQL Server Transaction Log Shrinking and Truncation
Sunday December 9, 2007
The transaction log plays a critical role in a SQL Server database: it maintains an ongoing record of database activity crucial for the restoration of recent data in the event of a disaster. However, this benefit comes at a cost: the transaction log can consume a substantial amount of space in an active database. SQL Server provides two actions designed to counterbalance these large space requirements: transaction log truncation and log file shrinking.
Read more in SQL Server Transaction Log Management
Read more in SQL Server Transaction Log Management


No comments yet. Leave a Comment