TRAINING CONTENTS
Module 1: Selecting the Appropriate High-availability Solution
· Identifying High-availability Requirements and Constraints
· Analyzing High-availability Requirements and Constraints
· Determining Appropriate High-availability Solutions
Lab : Proposing a High-availability Solution
· Gathering Requirements
· Prioritizing Requirements
· Determining Appropriate High-availability Technology
· Proposing a High-availability Solution
Module 2: Designing a Clustering Solution
· Designing the Platform for Clustering
· Designing the SQL Server Cluster Implementation
· Designing Recovery Strategies and Test Plans for Database Clustering
· Migrating and Upgrading SQL Server Clusters
· Designing an Operations Plan for Clustering
Lab : Designing a Database Clustering Solution
· Designing a Cluster Topology
· Designing an Operations Plan
· Verifying a SQL Server Cluster Configuration
· Monitoring a SQL Server Cluster
Module 3: Designing a Highly Available Database Storage Solution
· Determining Storage Requirements for SQL Server Databases
· Determining Storage Requirements for SQL Server Components and Files
· Designing Storage Solutions for SQL Server Databases
· Designing a Backup and Restore Strategy
Lab : Designing a Highly Available Database Storage Solution
· Determining Storage Needs
· Selecting the Storage Solution
· Designing a RAID Solution
· Designing a SAN Solution
· Designing a Backup and Restore Strategy
Module 4: Designing a Log Shipping Solution
· Introduction to Designing a Log Shipping Solution
· Designing Log Shipping Server Roles and Topology
· Designing a Log Shipping Upgrade Strategy
· Designing an Operations Plan for Log Shipping
Lab : Designing a Log Shipping Solution
· Selecting the Appropriate Log Shipping Architecture
· Designing Log Shipping Database Roles and Topology
· Designing an Operations Plan
· Verifying and Testing a Log Shipping Solution
Module 5: Designing a Database Mirroring Solution
· Introduction to Designing a Database Mirroring Solution
· Designing Database Roles and Topology for Database Mirroring
· Converting High-availability Solutions to Database Mirroring
· Designing an Operations Plan for Database Mirroring
Lab : Designing a Database Mirroring Solution
· Selecting the Appropriate Mirroring Architecture
· Designing Database Roles and Topology for Database Mirroring
· Designing an Operations Plan
· Evaluating Migration Options from Clustering to Mirroring
· Evaluating Migration Options from Log Shipping to Mirroring
· Comparing Mirroring with Clustering and Log Shipping
Module 6: Designing a Highly Available Solution Based on Replication
· Introduction to Designing a Replication Solution
· Designing a Replication Solution
· Designing a Replication Upgrade Strategy
· Designing an Operations Plan for Replication
Lab : Designing a Highly-availability Solution Based on Replication
· Selecting the Appropriate Replication Architecture
· Designing a Replication Solution
· Designing an Operations Plan
· Designing a Disaster Recovery Strategy By Using MERGE Replication
· Designing a Disaster Recovery Strategy By Using TRANSACTIONAL Replication
Module 7: Combining High-availability Technologies
· Evaluating Weaknesses in Each High-availability Technology
· Maximizing Availability by Combining High-availability Technologies
Lab : Combining High-availability Technologies
· Evaluating Weaknesses in High-availability Technologies
· Maximizing Availability by Combining Technologies
Module 8: Documenting and Testing a High-availability Strategy
· Documenting High-availability Solutions
· Creating a Test Plan for High-availability Solutions
Lab : Documenting and Testing a High-availability Strategy
· Documenting the High-availability Solution
· Creating a Test Plan