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

Configuring AlwaysOn Availability Groups


Earlier in this lesson, we discussed a typical AlwaysOn topology consisting of a primary replica and two secondary replicas. One secondary replica in the same region (geographic area) is used for high availability and another secondary replica in a different region is used for disaster recovery.

We'll now configure the same topology. However, the replicas used in the demos are not in a different subnet. In a real-world scenario, the replicas will be in different subnets; however, they'll be under the same domain and part of one WSFC.

Let's get started with configuring AlwaysOn AG.

Exercise 35: Enabling the AlwaysOn AG Feature

The first step is to enable the AlwaysOn feature for SQL Server instances at each replica. To do this, follow these steps:

  1. Connect to the DPLPR VM and open SQL Server 2016 Configuration Manager.

  2. Select SQL Server Services from the left-hand pane to list out the available SQL Server services. In the right-hand pane, right-click on SQL...