Logging and Recovery: Understand How Your Transactions Impact System Recovery and Performance

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 and why and when it causes performance problems? In this session you will 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. Know how to minimize data loss and get started on designing an effective recovery strategy!