Course 3170: Designing a Database Mirroring Solution Using Microsoft SQL Server 2005

Introduction In this course, you design database roles and topologies for database mirroring of Microsoft SQL Server 2005. You convert existing high-availability solutions to database mirroring and design an operations plan to maximize availability. In addition, you manage security events and threats in database mirroring.

This course also helps prepare you for certification exam 70-444: PRO: Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005. Objectives At the end of the course, students will be able to:

• Introduction to Designing a Database Mirroring Solution
• Design Database Roles and Topologies for Database Mirroring
• Convert High-Availability Solutions to Database Mirroring
• Design an Operations Plan for Database Mirroring
• Manage Threats in Database Mirroring

Modules & Lessons Course Overview Module Introduction Navigation Overview Lab Information High Availability Is More Than Just Technology Designing a Database Mirroring Solution Module Introduction Introduction to Designing a Database Mirroring Solution Lesson Introduction Scope of Protection Log Shipping vs. Database Mirroring Modes of Database Mirroring Factors That Impact a Database Mirroring Design Self Test Designing Database Roles and Topologies for Database Mirroring Lesson Introduction Database Roles and Topologies for Database Mirroring Forms of Role Switching The Impact of Database States on Availability Considerations for Connecting Applications to Mirrored Databases Guidelines for Designing a Disaster Recovery Strategy Testing Database Mirroring Self Test Converting High-Availability Solutions to Database Mirroring Lesson Introduction Considerations for Converting Log Shipping to Database Mirroring Considerations for Converting Clustering to Database Mirroring High-Availability Technologies That Complement Database Mirroring Self Test Designing an Operations Plan for Database Mirroring Lesson Introduction Process of Designing an Operations Plan Planned Operational Events Affecting Database Mirroring Unplanned Operational Events Affecting Database Mirroring Guidelines for Applying Service Packs and Hotfixes Applying Service Packs and Hotfixes Self Test Managing Threats in Database Mirroring Lesson Introduction Models for Managing Security Events Guidelines for Managing Security Events Guidelines for Managing Environment Differences Creating an Operations Plan to Manage Disaster Scenarios Self Test Lab: Designing a Database Mirroring Solution Lesson Introduction Scenario Exercise Lab Review Module Summary Glossary Module Introduction 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