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
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.