Taken from a series of popular sessions and shorter workshops this three day session is to be packed full of information while being interesting to listen to

Understanding Logging & Recovery:
Building an Effective Recovery Strategy
with SQL Server 2000

1-Day Workshop

Presented by Kimberly L. Tripp

Why you should attend?
Taken from a series of popular shorter sessions and workshops – including sessions that have been top rated at conferences around the world – this one day Master Class combines materials to create a cohesive and interesting fully packed one day course. Fast-paced and full of detailed technical content, Kimberly’s sessions are always interesting. In 2003 Kimberly was the top rated speaker at virtually every US event at which she lectured. In fact, at the US Microsoft Tech Ed event Kimberly delivered 5 sessions [out of 380] and all 5 were rated among the top 12 – including the number one spot! A common comment made regarding Kimberly’s presentations is that she has the gift of being able to communicate technical materials and make subjects that would otherwise be dull – somewhat interesting. Kimberly’s looking forward to this new combination workshop which pulls top sessions, top recommendations and some of the most effective ways to minimize data loss.

Abstract

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.

If you want to get a better grasp of: how transactions work, how logging works, how recovery works and how to build a strategy to minimize data loss …this exclusive master class is the place to be!