Course 3168: Designing a Clustering Solution Using Microsoft SQL Server 2005

Introduction In this course, you design, manage, and upgrade a Microsoft SQL Server 2005 clustering 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:

• Design the Platform for Clustering
• Design the SQL Server Cluster Implementation
• Design Recovery Strategies and a Test Plan for Database Clustering
• Migrate and Upgrade SQL Server Clusters
• Design an Operations Plan for Clustering

Modules & Lessons Course Overview Module Introduction Navigation Overview Lab Information High Availability Is More Than Just Technology Designing a Clustering Solution Module Introduction Designing the Platform for Clustering Lesson Introduction Features of Clustering Hardware Requirements for Clustering Guidelines for Selecting the Appropriate Windows Cluster Topology Requirements of a Geo-Clustering Solution Security Considerations Network Considerations Self Test Designing the SQL Server Cluster Lesson Introduction Configuring SQL Server Instances and Services Designing Resource Dependencies in a SQL Server Cluster Storage Needs for SQL Server Cluster Guidelines for Specifying Processor Configurations Guidelines for Specifying Memory Configurations Guidelines for Specifying Network Configurations Self Test Designing Recovery Strategies and a Test Plan for Database Clustering Lesson Introduction Identifying Disaster Scenarios in a SQL Server Cluster Designing Failover and Failback Strategies for a SQL Server Cluster Designing a Test Plan for a SQL Server Cluster Self Test Migrating and Upgrading SQL Server Clusters Lesson Introduction Considerations for Migrating to a Clustered Environment Designing a Migration Strategy and Test Plan Designing a SQL Server Cluster Upgrade Strategy Applying Service Packs And Hotfixes Self Test Managing a Clustered Environment Lesson Introduction Identifying Events Affecting Clustering Process of Designing an Operations Plan Managing Security Threats Guidelines for Managing Configuration Settings Managing Disaster Scenarios Self Test Lab: Designing a Database Clustering Solution Lesson Introduction Scenario Exercise Exercise 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