1. Computing

Discuss in my forum

Mike Chapple

Managing SQL Server Transaction Logs

By December 4, 2012

Follow me on:

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
Comments
December 5, 2012 at 5:01 am
(1) Chris says:

Just wanted to say thanks for article >>> Installing MySQL on Mac OS X 10.7 Lion – Saved me all kinds of time. :)

Leave a Comment

Line and paragraph breaks are automatic. Some HTML allowed: <a href="" title="">, <b>, <i>, <strike>
  1. About.com
  2. Computing
  3. Databases

©2014 About.com. All rights reserved.