Configure Azure SQL with Failover Groups

45 minutes
  • 2 Learning Objectives

About this Hands-on Lab

Azure SQL includes several features which help protect against outages. Auto-failover groups provide this protection with a range of built-in management capabilities to simplify failover.

In this hands-on lab, we’ll use the Azure portal to configure an auto-failover group for an existing Azure SQL server.

You’ve recently been employed as a cloud administrator, and you have been asked to address some concerns that were raised during a business continuity audit.

Following the audit, you have been asked to implement the following improvements for your Azure SQL service:

* Configure replication to improve high availability
* Ensure that you can recover promptly in the event of a region-wide disaster
* Ensure that failover is automated and includes DNS management

Learning Objectives

Successfully complete this lab by achieving the following learning objectives:

Create an Azure SQL Logical Server

In the Azure portal, create a new Azure SQL logical server in a different region from the existing Azure SQL logical server.

Configure Auto-Failover Groups

In the Azure portal, configure an Azure SQL auto-failover group from the existing Azure SQL logical server to the newly created Azure SQL logical server.

Additional Resources

Log in to the Azure portal by right-clicking Open Azure Portal and selecting the option to open it in a new private browser window. (This option will read differently depending on your browser — e.g., in Chrome, it reads Open Link in Incognito Window.) Then, sign in using the credentials provided on the lab page.

The objectives for this hands-on lab can be completed using the Azure portal.

What are Hands-on Labs

Hands-on Labs are real environments created by industry experts to help you learn. These environments help you gain knowledge and experience, practice without compromising your system, test without risk, destroy without fear, and let you learn from your mistakes. Hands-on Labs: practice your skills before delivering in the real world.

Sign In
Welcome Back!

Psst…this one if you’ve been moved to ACG!

Get Started
Who’s going to be learning?