Logging & Recovery
12 March 2004

Presented by Kimberly L. Tripp
Principal Mentor, Solid Quality Learning


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 you will learn best practices for keeping the transaction log manageable, how to evaluate different backup strategies and how to create the most effective recovery techniques. This session is NOT a point and click overview of the UI – from this session you will know the full range of backup and restore options, how to implement them, how to automate them and how to interrogate (and clean up) msdb's automatic logging of backups! Guarantee the safety of your corporate data by fully understanding your options and appropriately implementing a cost-effective and efficient recovery strategy.