Microsoft SQL Server 2008 High Availability with Clustering & Database Mirroring

Home >
Browse >
Microsoft SQL Server 2008 High Availability with Clustering & Database Mirroring

Microsoft SQL Server 2008 High Availability with Clustering & Database Mirroring

Authors: Michael Otey

Published: December 2009

eISBN: 9780071596077 0071596070 | ISBN: 9780071498135

Contents

Acknowledgments

Introduction

Chapter 1 Planning for High Availability

Defining High Availability

Factors Influencing Availability

Personnel Factors

Operational Factors

Technical Factors

Part I: Implementing Windows Failover Clustering

Chapter 2 Windows Failover Clustering Architecture

Overview

Windows Failover Cluster Configurations

Windows Failover Cluster Components

New Failover Clustering Features in Windows Server 2008

SQL Server 2008 Failover Clustering Support

Chapter 3 Configuring Failover Clustering

Configuring Windows Server 2008 Shared Storage

Adding the Failover Clustering Feature

Configuring Failover Clustering

Chapter 4 Configuring SQL Server Failover Clustering

Installing Microsoft Distributed Transaction Coordinator on the Cluster

Installing Server 2008 on the First Cluster Node

Installing Server 2008 on the Second Cluster Node

Chapter 5 Managing Failover Clustering

Managing the Cluster

Backing Up the Cluster

Part II: Implementing Database Mirroring

Chapter 6 Database Mirroring Architecture

Database Mirroring Requirements

Database Mirroring Architecture

Database Mirroring Modes

Client Failover

Using Database Snapshots for Reporting

Combining Database Mirroring and Failover Clustering

Chapter 7 Configuring Database Mirroring

Database Mirroring Requirements

Initializing Database Mirroring

Configuring Mirroring on the Principal Server

Chapter 8 Managing Database Mirroring

Managing the Mirroring Session

Monitoring Database Mirroring

Verifying Your Database Mirroring Configuration

Part III: Implementing Hyper-V Virtualization and Live Migration

Chapter 9 Virtualization and Live Migration Architecture

An Overview of Virtualization

High Availability and Virtualization

Live Migration Architecture

Chapter 10 Configuring Hyper-V Live Migration

Configuring Windows Server 2008 Shared Storage

Adding the Hyper-V Role

Adding the Failover Clustering Feature

Configuring Failover Clustering for Live Migration

Configuring Cluster Shared Volumes

Chapter 11 Configuring SQL Server with Hyper-V Live Migration

Creating a Hyper-V VM with Live Migration

Installing Windows Server 2008 on the VM

Installing SQL Server 2008 on the VM

Configuring the SQL Server VM for Live Migration

Chapter 12 Managing the Virtual SQL Server

Managing the Highly Available Virtual SQL Server

Virtual Machine Management Using the Hyper-V Manager

Virtual Machine Management Using the Failover Cluster Manager

Performing a Live Migration

Performing a Quick Migration

System Center Enterprise Suite

Index