SQL Server 2005 > MOC 2788: Desg. High Aval. Database Solutions Using SQL 2005

MOC 2788: Desg. High Aval. Database Solutions Using SQL 2005


MOC 2788: Designing High Availability Database Solutions Using SQL Server 2005

PACKAGE INCLUDES

  • 8 CD-ROMs featuring live instructor-led classroom sessions with full audio, video and demonstration components
  • Printable courseware
  • Sample Code
  • Step-by-step hands-on-labs
  • Comprehensive, understandable, and reusable as reference material


    • Single User CD Course
    £ 248
    Single User Online Course
    £ 198
    Multi User CD Course
    £ 496

    COURSE INTRODUCTION

    The Technology Specialist certifications enable professionals to target specific technologies and distinguish themselves by demonstrating in-depth knowledge and expertise in their specialized technologies.

    This instructor-led course enables database administrators who work with enterprise environments to design security for database systems using Microsoft SQL Server 2005. The course emphasizes that students should think about the whole environment, which includes business needs, regulatory requirements, network systems, and database considerations during design. Students will also learn how to monitor security and respond to threats.

    Course Outline


    Course Introduction

    Course Introduction

    Module 1 - Selecting the Appropriate High-Availability Solution

    Selecting the Appropriate High-Availability Solution
    Minimum Requirements for a High-Availability Solution
    Identifying Requirements and Constraints
    Identifying Business Needs
    Identifying Technical Constraints
    Identifying Failback and Failover Policies
    Analyzing Requirements and Constraints
    Guidelines for Analyzing Requirements
    Analyzing Constraints
    Analyzing the Potential Cost of a Solution
    Module 1 Review

    Module 2 - Designing a Highly Available Database Storage Solution

    Designing a Highly Available Database Storage Solution
    Storage Requirements for Databases
    Storage Requirements for System Databases
    Storage Requirements for TempDB
    Storage Requirements for Components and Files
    Storage Requirements for SQL Server Components
    Full-Text Indexes
    External Files
    Trace and Event Log Files
    Log Policies
    Backup Files
    Storage Solutions for Databases
    File and Filegroup Structures for Database Data
    File Structures for Transaction Logs
    Storage Solutions for System Databases
    Backup and Restore Strategy
    Designing a Restore Strategy
    Designing a Recovery Strategy for System Databases
    Designing a Recovery Strategy for User Databases
    Designing a Database Strategy That Includes Database Snapshots
    Module 2 Review

    Module 3 - Designing a Failover Clustering Solution

    Designing a Failover Clustering Solution
    Designing the Platform for Failover Clustering
    Overview of Failover Clustering
    Scope of Protection
    Key Components of a Cluster Environment
    Hardware Requirements for Clustering
    Selecting the Appropriate Windows Cluster Topology
    Single Instance Cluster
    Multiple Instance Cluster
    N + 1 Cluster
    N + M Cluster
    Designing a Geo-Clustering Solution
    Network Considerations for a Cluster Environment
    Designing the SQL Server Cluster Implementation
    Instances and Services
    Specifying Processor Resource Configurations
    Specifying Memory Configurations
    Specifying Network Configurations
    Designing Recovery Strategies and a Test Plan
    Disaster Recovery Strategy for a Cluster
    Test Plan for a SQL Server Cluster
    Migrating and Upgrading Clusters
    Migration Strategy for a Non-Clustered Instance
    Applying Service Packs and Hotfixes
    Designing an Operations Plan for Clustering
    Designing an Operations Plan
    Operational Events Affecting Clustering
    Managing Security Events
    Managing Incorrect Configuration Settings
    Technologies That Complement Clustering
    Module 3 Review

    Module 4 - Designing a Log Shipping Solution

    Designing a Log Shipping Solution
    Introduction to Designing a Log Shipping Solution
    Scope of Protection
    Factors That Impact a Log Shipping Design
    Designing Log Shipping Server Roles and Topology
    Log Shipping Server Roles and Topology
    Process of Changing Server Roles
    Designing a Log Shipping Upgrade Strategy
    Upgrading from SQL Server 2000 to SQL Server 2005
    Applying Service Packs and Hotfixes
    Designing an Operations Plan
    Events Affecting Log Shipping
    Managing Security Events
    Managing Environment Differences
    Technologies That Complement Log Shipping
    Module 4 Review

    		 

    Module 5 - Designing a Database Mirroring Solution

    Designing a Database Mirroring Solution
    Introduction
    Log Shipping vs. Database Mirroring
    Scope of Protection
    Modes of Database Mirroring
    Factors That Impact a Database Mirroring Design
    Designing Database Roles and Topology
    Database Roles and Topology
    Designing a Database Mirroring Topology
    Changing Database Roles
    The Impact of Database States on Availability
    Testing Database Mirroring
    Converting High-Availability Solutions to Database Mirroring
    Converting Log Shipping to Database Mirroring
    Converting Clustering to Database Mirroring
    Designing an Operations Plan
    Operational Events Affecting Database Mirroring
    Managing Environment Differences
    Applying Service Packs and Hotfixes
    Technologies That Complement Database Mirroring
    Module 5 Review

    Module 6 - Designing Replication Solutions for High Availability

    Designing Replication Solutions for High Availability
    Introduction
    Scope of Protection
    Types of Replication
    Factors To Consider
    Designing a Replication Solution
    Server Roles and Topology
    Selecting Replication Type
    Designing Replication Strategies
    Immediate/Queued Updating
    Merge Replication
    Replication-Aware Applications
    Designing an Upgrade Strategy
    Applying Service Packs and Hotfixes
    Operation Plan for Replication
    Events Affecting Replication
    Operational Events Affecting Replication
    Managing Security Events
    Managing Environment Differences
    Technologies That Complement Replication
    Module 6 Review

    Module 7 - Combining High-Availability Technologies

    Combining High-Availability Technologies
    Weaknesses in Each High-Availability Technology
    Weaknesses in Clustering
    Weaknesses in Log Shipping
    Weaknesses in Database Mirroring
    Weaknesses in Replication
    Combining High-Availability Technologies Cont.
    Maximize Availability with Log Shipping
    Maximize Availability with Database Mirroring
    Maximize Database and Server Availability with Replication
    Maximize Database Availability with Clustering
    Module 7 Review

    Module 8 - Documenting and Testing a High-Availability Strategy

    Documenting and Testing a High-Availability Strategy
    Documenting High-Availability Solutions
    Documenting Business Requirements
    Validating the Selected Solution
    Documenting the Selected Solution
    Documenting the Selected Solution Guidelines
    Documenting Failover and Failback Strategies
    Documenting Threats to the Selected Solution
    Test Plan for High-Availability Solutions
    Testing a High-Availability Solution
    Determining Performance Benchmarks
    Business and Regulatory Requirements
    Module 8 Review
    Course Closure
    Page Execution time is 4.688 seconds.