목차

Lesson 1: Introduction to High Availability

Factors Affecting Availability

Considerations for Optimizing Database Availablity

Lesson 2: Implementing Server Clustering

What Is Server Clustering?

Considerations for Cluster Preparation

Check configuration and compatibility of:

How to Install SQL Server in a Cluster

Lesson 3: Implementing Database Mirroring

What Is Database Mirroring?

Options for Database Mirroring Configuration

Mode Automatic Failover Full Protection from Data Loss
High Availability O O
High Protection X O
High Performance X X

What Are Database Mirroring Endpoints?

How to Prepare Servers for Database Mirroring

  1. Create mirroring endpoints and logins
  2. Set recovery model to FULL
  3. Back up database and restore on mirror server
  4. Copy server-level resources

How to Establish a Mirror Session

  1. Set the pricipal server on the mirror server
  2. Set the server on the principal server
  3. Change the session mode from High Protection
    • Add a witness server for High Availability mode
    • Set partner safety off for High Performance mode

How to Handle Failover

Lesson 4: Implementing Log Shipping

What Is Log Shipping?

How to Implement Log Shipping

How to Switch Server Roles

  1. Copy transaction log backups
  2. Back up primary database with NORECOVERY
    BACKUP LOG AdventureWorks TO AWLogBackup
    WITH NORECOVERY
  3. Restore primary database on secondary server
    RESTORE LOG AdventureWorks FROM AWLogBackup
    WITH RECOVERY
  4. Disable log shipping jobs
  5. Configure log shipping on new primary server

Lesson 5: Implementing Peer-ot-Peer Replication

Considerations for Using Peer-to-Peer Replication

Implementing Distributed Load Balancing

Implementing Distributed High Availability