Logging and recovery are critical parts of SQL Server, but they are often poorly understood.
In the February 2009 issue of TechNet Magazine, Paul Randal answers these common questions and provides important advice for managing your database environment. He gives an overview of how the logging and recovery features work in SQL Server and explains the transaction log and recovery models to help you maintain a better database.
Paul has also provided a video where he demonstrates the importance of managing your transaction log properly in the full recovery model, and he shows you techniques for doing so in SQL Server.
Read the article and watch the video now.