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 on Microsoft Azure


Azure is a cloud platform offering from Microsoft that has a vast set of services for organizations to build and deploy applications. Deploying a SQL Server AlwaysOn availability group on Microsoft Azure is not a lot different than deploying it on-premises. The requirements, components, and prerequisites remain the same; however, the implementation differs.

Exercise 38: Configuring an AlwaysOn Availability Group on Microsoft Azure

To configure a two-node AlwaysOn AG on Azure, we still need a domain controller, a primary replica, a secondary replica, and an AlwaysOn listener. However, the VMs are provisioned on Azure and Azure VMs require a load balancer. An AlwaysOn AG on Azure can either be configured manually or automatically by using the SQL Server AlwaysOn Cluster template.

In this exercise, we'll configure an AlwaysOn AG using the SQL Server AlwaysOn Cluster template. Follow these steps to configure an AlwaysOn AG on Microsoft Azure.

Note

You...