Book Image

Professional SQL Server High Availability and Disaster Recovery

By : Ahmad Osama
Book Image

Professional SQL Server High Availability and Disaster Recovery

By: Ahmad Osama

Overview of this book

Professional SQL Server High Availability and Disaster Recovery explains the high availability and disaster recovery technologies available in SQL Server: Replication, AlwaysOn, and Log Shipping. You’ll learn what they are, how to monitor them, and how to troubleshoot any related problems. You will be introduced to the availability groups of AlwaysOn and learn how to configure them to extend your database mirroring. Through this book, you will be able to explore the technical implementations of high availability and disaster recovery technologies that you can use when you create a highly available infrastructure, including hybrid topologies. Note that this course does not cover SQL Server Failover Cluster Installation with shared storage. By the end of the book, you’ll be equipped with all that you need to know to develop robust and high performance infrastructure.
Table of Contents (9 chapters)
Professional SQL Server High Availability and Disaster Recovery
Preface

AlwaysOn Availability Groups


In this lesson, we'll configure AlwaysOn AGs on a three node Windows Server Failover Cluster. We'll first look at the prerequisites for the setup and will then do the following:

  • Set up four Hyper-V VMs; one VM will act as a domain controller and the other three will be the availability group replicas

  • Set up AlwaysOn AGs

The AlwaysOn topology to be configured is shown in the following diagram. This is the same topology as discussed earlier in this lesson:

Figure 4.6: AlwaysOn topology

As a part of the AlwaysOn availability setup, we'll also configure a domain controller. In a real-world scenario, configuring a domain controller and Windows Server Failover Cluster is part of a System Administrator's job.

We'll also talk about modifying an existing availability group such as adding/removing a database from an availability group, modifying backup preferences, and adding a new replica.

Prerequisites

In this section, we'll discuss the prerequisites for configuring availability...