TechNet Virtual Lab: Microsoft SQL Server 2008 Data Recovery and Preventative Techniques  

After completing this lab, you will be better able to understand the availability problems associated with human error, understand how foreign keys protect referenced tables but not referencing tables, use point-in-time recovery to retrieve deleted data from a database backup, use tablediff.exe to aid in targeted data recovery where more than INSERTs were lost – UPDATEs and DELETEs were also lost, and use DDL Triggers to prevent table drops and other DDL operations.
 


Note
By registering for this virtual lab, you will receive a one-time follow up call from a Microsoft representative to inform you of special discounts and offers related to products and services presented in the virtual lab.