Live@DL

1083

Microsoft SQL Server High Availability 2005

Table of Contents

Introduction
Audience
At Course Completion
Prerequisites
Microsoft Certified Professional Exams
Student Materials
Course Outline

Introduction

Microsoft® SQL Server™ 2005 High Availability Bootcamp is an advanced, five-day, skills-based course for Microsoft® SQL Server™ 2005 High Availability solutions. This course provides the SQL Server™ 2005 database administrator the advanced knowledge and hands-on experience necessary to design, implement, and administer SQL Server™ 2005 High Availability solutions. This focus is achieved by providing the technical and business knowledge needed to predictably achieve high availability in a SQL Server™ 2005 database environment.

This course is designed to provide the database professional with knowledge of high availability solutions which goes beyond that achieved from introductory level courses currently found on the market. This advanced knowledge is not only achieved from the course materials, it is achieved from the experience of the instructors Solid Quality Learning has qualified to deliver this material.

Return to Top

Audience

This course is intended for database administrators who administer Microsoft® SQL Server™ 2005 databases. Specific audience segments include:

• Corporate database administrators who desire to learn Microsoft® SQL Server™ 2005 High Availability solutions to become more effective in their daily jobs
• Server providers and systems integrators who are tasked with providing High Availability solutions for their clients
• Database Architects who need to understand High Availability solutions

Return to Top

At Course Completion

This Microsoft® SQL Server™ 2005 High Availability Bootcamp provides in-depth technical information about SQL Server 2005 High Availability techniques. This bootcamp will focus on the creation and implementation of High Availability solutions by combining both instructor material and by using a practical approach through hands on labs.

After completing this workshop students will be able to:

• Manage simple SQL Server 2005 failures through backup and restore techniques
• Use SQL Server files and filegroups for High Availability
• Implement and administer a SQL Server 2005 clusters
• Implement and administer a SQL Server 2005 replicated environment
• Implement and administer a SQL Server 2005 database mirroring
• Implement and administer a SQL Server 2005 log shipping
• Implement and administer a SQL Server 2005 snapshots
• Understand the difference between RAID levels
• Understand how to upgrade High Availability solutions
• Implement and administer high availability maintenance
• Monitor High Availability Solutions

Return to Top

Prerequisites

This course requires that students meet the following prerequisites:

• Knowledge of hardware terminology and concepts
• Knowledge of Windows 2000 and Windows 2003 administration concepts:
  • Windows Clustering
  • Windows Security
  • Disk subsystems
  • RAID
• Experience with Microsoft® SQL Server™ 2005 database administration
• Knowledge obtained from Microsoft® Course 2788: Designing High Availability Database Solutions Using Microsoft SQL Server 2005

.

Return to Top

Microsoft Certified Professional Exams

No MCP exam currently exists for this course.

Return to Top

Student Materials

The student kit includes a comprehensive workbook and other necessary materials for this class.

Return to Top

Course Outline

Module 01: High Availability Overview

This module describes basic high availability concepts and allows the students to become familiar with high availability terminology they may not understand.

• Defining High Availability
• High Availability Framework

Module 02: SQL Server 2005 High Availability Overview

This module describes basic high availability concepts as it relates to SQL Server 2005 and allows the students to become familiar with high availability concepts they may not understand.

• Introduction to SQL Server High Availability
• Introduction to Clustering
• Introduction to Database Mirroring
• Introduction to Replication
• Introduction to Log Shipping
• Introduction to Database Snapshots
• Introduction to Online Maintenance
• Backup and Restore
• Fast Recovery

Module 03: Using Files and Filegroups for High Availability

This module describes how SQL Server 2005 implementation can utilize files and filegroups to achieve high availability goals.

• SQL Server Files
• SQL Server Filegroups

Module 04: SQL Server 2005 Backup and Restore

This module describes how SQL Server 2005 implementation can utilize backup and restore techniques to achieve high availability goals.

• Online Restores
• Partial Backup and Piecemeal Restores
• Single Page Restores

Module 05: Replication Overview

This module describes the guidelines and considerations for designing and administrating a high availability solution based on SQL Server 2005 replication. This module provides the guidelines for determining replication server roles and topology and explains the process of designing SQL Server 2005 replication.

• Replication Overview
• Replication Agents
• Replication Security
• Replication Administration

Module 06: Snapshot Replication

This module describes the guidelines and considerations for designing and administrating a high availability solution based on SQL Server 2005 Snapshot Replication. This module provides the guidelines for determining a Snapshot Replication topology and explains the process of designing SQL Server 2005 Snapshot Replication.

• Snapshot Replication Overview
• When to choose Snapshot Replication
• Snapshot Replication Considerations

Module 07: Transactional Replication

This module describes the guidelines and considerations for designing and administrating a high availability solution based on SQL Server 2005 Transactional Replication. This module provides the guidelines for determining a Transactional Replication topology and explains the process of designing SQL Server 2005 Transactional Replication.

• Transactional Replication Overview
• Transactional Replication High Availability options
• Transactional Replication Setup
• Managing Transactional Replication

Module 08: Merge Replication

This module describes the guidelines and considerations for designing and administrating a high availability solution based on SQL Server 2005 Merge Replication. This module provides the guidelines for determining a Merge Replication topology and explains the process of designing SQL Server 2005 Merge Replication.

• Merge Replication Overview
• Merge Replication Conflict Resolver
• Merge Replication Considerations
• Merge Replication Performance Tuning
• Merge Replication Web Synchronization

Module 09: Peer-To-Peer Replication

This module describes the guidelines and considerations for designing and administrating a high availability solution based on SQL Server 2005 Peer-to-Peer Replication. This module provides the guidelines for determining a Peer-to-Peer Replication topology and explains the process of designing SQL Server 2005 Peer-to-Peer Replication.

• Bidirectional and Peer-to-Peer Overview
• Bidirectional Transactional Replication
• Peer-to-Peer Transactional Replication

Module 10: Database Mirroring

This module describes the guidelines and considerations for designing and administrating a high availability solution based on SQL Server 2005 Database Mirroring. This module provides the guidelines for determining a mirroring topology and explains the process of designing SQL Server 2005 Database Mirroring.

• Overview
• Database Mirroring Considerations
• Asynchronous Database Mirroring
• Synchronous Database Mirroring
• Database Mirroring and Log Shipping
• Database Mirroring and Replication
• Database Mirroring and Database Snapshots

Module 11: Database Snapshots

This module describes the guidelines and considerations for designing and administrating a high availability solution based on SQL Server 2005 Database Snapshots. This module provides the guidelines for determining a snapshot topology and explains the process of designing SQL Server 2005 Database Snapshots.

• Overview
• Using Database Snapshots
• Snapshot Considerations
• Reverting from a snapshot

Module 12: Log Shipping

This module describes the guidelines and considerations for designing and administrating a high availability solution based on SQL Server 2005 Log Shipping solution. This module provides the guidelines for determining a log shipping topology and explains the process of designing SQL Server 2005 Log Shipping.

• Log Shipping Overview
• SQL Server 2005 Log Shipping
• Log Shipping Failover

Module 13: RAID Configurations

This module describes how SQL Server 2005 implementations can utilize backup and restore techniques to achieve high availability goals.

• Overview of RAID
• RAID 0
• RAID 1
• RAID 5
• RAID 1+0
• Other RAID Levels

Module 14: SAN Snapshots

This module describes how SQL Server 2005 can implement SAN Snapshots to achieve high availability goals.

• What are Split-Mirror Backups?
• How do split-mirror backups work?
• How can you synchronize your backups?
• How can you restore from the backup?
• Split-Mirror backup considerations
• Module 15: Mount Points
• This module describes how SQL Server 2005 can implement mount points to achieve high availability goals.
• Mount Points

Module 16: Hot Memory

This module describes how SQL Server 2005 can implement Hot Add Memory to achieve high availability goals.

• What is Hot Add Memory?

Module 17: Clustering

This module describes the guidelines and considerations for designing and administrating a high availability solution based on SQL Server 2005 Clustering. This module provides the guidelines for determining a clustered solution and explains the process of designing SQL Server 2005 Clustered environment.

• Windows Clustering Concepts
• Service Cluster Process
• Windows Clustering Best Practices
• Windows Clustering Administration
• SQL Server 2005 Clustering Architecture
• Installing a SQL Server 2005 Failover Cluster
• Managing a SQL Server 2005 Failover Cluster

Module 18: High Availability Upgrades

This module discusses how to upgrade an existing High Availability solution to SQL Server 2005. The module describes upgrading clustered databases, replicated databases, log shipping databases, and regular database environments in a high availability manner.

• High Availability Upgrade Options
• Upgrading clustered database
• Upgrading replicated databases
• Upgrading log shipping

Module 19: High Availability Maintenance

This module describes how the database administrator can achieve database maintenance in a highly available manner. The module discusses the techniques needed to maintain a database without affecting the usability of that database.

• Online Indexing
• Internal Snapshots

Module 20: High Availability Monitoring

This module describes how to monitor high availability methodologies. This module discusses common monitoring techniques and tools used to keep different high availability solutions operating at peak efficiency.

• Overview
• Replication Monitor
• Replication Alerts
• Database Mirroring Monitor
• Log Shipping Report
• System Monitor
• SQL Server Profiler
• System Catalog Views and Stored Procedures

Return to Top