Course 10145: Protecting and Recovering SQL Server Data with DPM 2007

Introduction In this 2-hour online course, IT Professionals will learn how to protect and recover SQL Server Data with DPM 2007. Topics covered in this course include:

• Planning SQL Server Protection
• Protecting SQL Server Data with DPM 2007
• Recovering SQL Server Data with DPM 2007

Student prerequisites

To get the most out of this course, the target audience should have previous experience of backup programs and some experience with the following core applications:

• Microsoft SQL Server

Objectives At the end of the course, students will be able to:

• After completing this 2-hour online course for IT Professionals, students will be able to:
• Plan protection of your SQL Server data.
• Protect SQL Server data with DPM 2007.
• Recover SQL Server data with DPM 2007.

Modules & Lessons Course Overview Module Overview Navigation Overview Navigation Overview Course Information Course Information Protecting and Recovering SQL Server Data with DPM 2007 Module Overview Planning SQL Server Protection Planning SQL Server Protection Overview of SQL Server Data Protection Choosing Which SQL Server Data to Protect Overview of Recovery Goals for SQL Server Data Determining Recovery Goals for SQL Server Data Self Test Protecting SQL Server Data with DPM 2007 Protecting SQL Server Data with DPM 2007 Guidelines for SQL Server Protection Groups Selecting a Data Protection Method Configuring Protection Groups Considerations for Protecting SQL Server Data SQL Server Protection Options The Process to Create SQL Server Protection Groups Self Test Recovering SQL Server Data with DPM 2007 Recovering SQL Server Data with DPM 2007 Introduction to SQL Server Recovery Methods Choosing SQL Server Recovery Methods Recovery Options The Process to Recover SQL Server Data Self Test Lab: Protecting and Recovering SQL Server Data Lab: Protecting and Recovering SQL Server Data Exercise Information Launch the Lab Lab Review Module Summary Module Summary System Requirements To view this course, you need:

• A Pentium II, 256 MB RAM with a processor speed greater than or equal to 400 MHZ
• Microsoft® Windows® 2000 or higher
• Microsoft Internet Explorer 6.0 or higher
• Adobe Flash 7.0 or higher (1MB disk space needed to install)
• Microsoft Silverlight 4.0 or higher
• Microsoft Windows Media Player 7.0 or higher
• Microsoft XML Core Services 3.0 or higher
• A Super VGA monitor with minimum screen resolution 1024x768, with 16-bit color.
• A sound card, and either speakers or headphones (for multi-media audio).
• Internet bandwidth of 56K or faster. Broadband internet access is recommended.

For courses containing Virtual Server-based labs (courses in the IT Professional and Developer Catalog), you will need:

• Microsoft Virtual Server ActiveX control (1MB disk space needed to install)

Test your computer's capabilities to see if it supports this course. Accessibility Requirements The following software must be running on your computer in order to access this course with Screen Reader Software:

• Microsoft Internet Explorer 6.0 or higher
• Window-Eyes from GW Micro
• JAWS from Freedom Scientific
• MSAA enabled