The goal of these lab materials is to get an understanding of how to use various features of SQL Server 2008 R2 for data recovery and techniques to reduce or prevent data loss. After completing these self-paced labs, you will be able to: 1.Understand the availability problems associated with human error; 2.Understand how foreign keys protect referenced tables but not referencing tables; 3.Use point-in-time recovery to retrieve deleted data from a database backup; 4.Use tablediff.exe to aid in targeted data recovery where more than INSERTs were lost – UPDATEs and DELETEs were also lost;Use DDL Triggers to prevent table drops and other DDL operations.