Deploying SQL Server Availability Groups in Azure
Lab
Intermediate
1 h 35 m
2019-12-08
Lab Overview
In this lab, you will configure several virtual machines that have been pre-deployed into an Azure subscription. This includes: one domain controller and two SQL Servers. You will thencreate an Azure Storage account that will be used as a Cloud Witness for the cluster, a Windows Failover Cluster across the two SQL Servers with the storage account acting as a witness. You will then create a SQL ServerAvailability Group with an Azure Internal Load Balancer and validate failover works correctly.Note: This lab pre-provisions several virtual machines and may take more than 30 minutes to complete provisioning.

Related Learning Path(s):
SQL Server 2016 Advanced Features
Objectives
  • Building a Windows Failover Cluster in Azure using a Cloud Witness
  • Setup and configure a SQL Server Availability Group in Azure
  • Configure an Internal Load Balancer for your Availability Group
Exercises
In this exercise, you will configure a Windows Failover Cluster across the three virtual machines to support a SQL Server Always On Availability Group.
In this task, you will setup a SQL Server Always On Availability Group across the two instances of SQL Server
In this exercise, you will create the internal load balancer used to support access to the SQL Server Availability Group in Azure. The load balancer is required to support automatically routing clients to the active primary server when the availability group is running in Azure
Real-Time Lab
Not Registered?
Create Account
Already Registered?
Login
What are Labs?

Labs provide a live environment to get hands-on experience using the same tools and services in the real world.


Learn More