Course 3172: Combining High-Availability Technologies Using Microsoft SQL Server 2005

Introduction In this course, you evaluate the weaknesses in each high-availability technology for Microsoft SQL Server 2005 including clustering, log shipping, database mirroring, replication, and storage technologies. You then apply guidelines for maximizing availability by combining existing technologies.

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:

• Identify Weaknesses in Each High-Availability Technology
• Maximize Availability by Combining High-Availability Technologies

Modules & Lessons Course Overview Module Introduction Navigation Overview Lab Information High Availability Is More Than Just Technology Combining High-Availability Technologies Module Introduction Weaknesses in Each High-Availability Technology Lesson Introduction Weaknesses in Clustering Weaknesses in Log Shipping Weaknesses in Database Mirroring Weaknesses in Replication Weaknesses in Storage Technologies Self Test Maximizing Availability by Combining High-Availability Technologies Lesson Introduction Maximizing Server Availability in Log Shipping Maximizing Server Availability in Database Mirroring Maximizing Database and Server Availability in Replication Maximizing Database Availability in Clustering Guidelines for Minimizing Threats Self Test Lab: Combining High-Availability Technologies 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