Course 3173: Documenting and Testing a High-Availability Strategy Using Microsoft SQL Server 2005

Introduction In this course, you document a Microsoft SQL Server 2005 high-availability solution. You apply guidelines for documenting business requirements, failover and failback strategies, performance benchmarks, threats, and a test plan to your selected solution.

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:

• Document High-Availability Solutions
• Test High-Availability Solutions

Modules & Lessons Course Overview Module Introduction Navigation Overview Lab Information High Availability Is More Than Just Technology Documenting and Testing a High-Availability Strategy Module Introduction Documenting High-Availability Solutions Lesson Introduction The Structure of a High-Availability Solution Document Guidelines for Documenting Business Requirements Guidelines for Validating the Selected Solution Documenting a High Availability Solution Guidelines for Documenting Failover and Failback Strategies Guidelines for Documenting Threats to the Selected Solution Self Test Testing a High-Availability Strategy Lesson Introduction Process of Testing a High-Availability Strategy Guidelines for Determining Performance Benchmarks Adhering to Business and Regulatory Requirements Self Test Lab: Documenting and Testing a High-Availability Strategy 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