Invalid Login Attempt

Lab: Deploying SQL Server Availability Groups in Azure

Overview


Details
  • Estimated time required to complete: 2 hours, 0 minutes
  • You will have access to this environment for 6 hours, 0 minutes
  • Learning Credits Required: 5
Who this lab is designed for
  • Database Administrators
  • Database Developers
  • Database Architects
  • IT Pros

Learning Objectives

  • Building a Windows Failover Cluster in Azure
  • Setup and configure a SQL Server Availability Group in Azure
  • Configure an Internal Load Balancer for your Availability Group

Exercises

Exercise 1: Environment Setup

In this first exercise, you will deploy the environment used throughout the lab by downloading and deploying an Azure Resource Manager template that will provision the environment.

Exercise 2: Create the Windows Failover Cluster
In this exercise, you will configure a Windows Failover Cluster across the three virtual machines to support a SQL Server Always On Availability Group.
Exercise 3: Create the SQL Server Availability Group
In this task, you will setup a SQL Server Always On Availability Group across the two instances of SQL Server
Exercise 4: Configure the Internal Load Balancer
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
Exercise 5: Cleanup Resources
In this task, you will cleanup all resources from this exercise to prevent unnecessary charges.

Login to Start Lab


Not Registered? Already Registered?
Benefits
Real Time Labs allow you to learn technology in an isolated environment without the hassle or cost of setting up a dedicated learning environment.

How it works