Contents

About the Author

About the Technical Reviewers

image Chapter 1: High Availability and Disaster Recovery Concepts

Level of Availability

Service-Level Agreements and Service-Level Objectives

Proactive Maintenance

Recovery Point Objective and Recovery Time Objective

Cost of Downtime

Classification of Standby Servers

Summary

image Chapter 2: Understanding High Availability and Disaster Recovery Technologies

AlwaysOn Failover Clustering

Active/Active Configuration

Three-Plus Node Configurations

Quorum

Database Mirroring

AlwaysOn Availability Groups

Automatic Page Repair

Log Shipping

Recovery Modes

Remote Monitor Server

Combining Technologies

Summary

image Chapter 3: Implementing a Cluster

Building the Cluster

Installing the Failover Cluster Feature

Creating the Cluster

Configuring the Cluster

Changing the Quorum

Configuring MSDTC

Configuring a Role

Summary

image Chapter 4: Implementing an AlwaysOn Failover Clustered Instance

Building the Instance

Preparation Steps

Cluster-Specific Steps

Installing the Instance with PowerShell

Adding a Node

Summary

image Chapter 5: Implementing AlwaysOn Availability Groups

Implementing High Availability with AlwaysOn Availability Groups

Configuring SQL Server

Creating the Availability Group

Performance Considerations for Synchronous Commit Mode

Implementing Disaster Recovery with Availability Group

Configuring the Cluster

Configuring the Availability Group

Adding AlwaysOn Readable Secondary Replicas

Summary

image Chapter 6: Administering AlwaysOn

Managing a Cluster

Moving the Instance between Nodes

Removing a Node from the Cluster

Managing AlwaysOn Availability Groups

Failover

Synchronizing Uncontained Objects

Monitoring

Adding Multiple Listeners

Other Administrative Considerations

Summary

Index

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset