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
Just wanted to say thanks for article >>> Installing MySQL on Mac OS X 10.7 Lion – Saved me all kinds of time.