Logging and Recovery: Understand How Your Transactions Impact System Recovery and Performance (DAT361)

Tech*Ed Conference Session, 75 minutes
Written/Presented by Kimberly L. Tripp, SQLskills.com

When the transaction log fills or becomes [excessively] large many developers run right for automating periodic truncation of the transaction log (trunc. log on chkpt. in SQL Server 7.0 or "simple" recovery model in SQL Server 2000). While you have simplified one problem (managing the transaction log); you have created another. Do you really understand what the transaction log is for and why and when it causes performance problems? In this session, learn best practices for keeping the transaction log manageable, how transaction logging affects performance and recovery as well as when to set and or change between each of the Recovery Models. Learn how to minimize data loss!