Setting up Failover Group in Azure SQL Managed Instance
Learn how to create a Failover Group between two Azure SQL Managed Instances. A failover group is a disaster recovery mechanism that allows all user databases within an Azure SQL Managed Instance to fail over as a unit to another Azure region, in case the primary SQL Managed Instance becomes unavailable due to a primary region outage. The video will cover the main pre-requirements and necessary Azure resources to build it properly.
Video by Andre Rodrigues.
Chapters:
00:00 Introduction
00:15 SQL MI primary instance details
00:39 Deploying SQL MI secondary instance
01:23 Configuring Global Virtual Network peering
02:26 Creating SQL MI Failover Group
02:50 Failover testing
03:05 Failback testing
🍿 Watch next | License free geo-secondary • Configuring failover rights license b...
📚 Read next | Next-gen General Purpose https://aka.ms/sqlmi-nextgp
📩 SQL MI Newsletter | https://aka.ms/sqlmi-letter
Resource Links:
What is Azure Virtual Network?: https://learn.microsoft.com/en-us/azu...
Virtual network peering: https://learn.microsoft.com/en-us/azu...
Cross-region replication in Azure: Business continuity and disaster recovery: https://learn.microsoft.com/en-us/azu...
Auto-failover groups overview & best practices (Azure SQL Managed Instance): https://learn.microsoft.com/en-us/azu...
What is Azure SQL Managed Instance?: https://learn.microsoft.com/en-us/azu...
What's new in Azure SQL Managed Instance?: https://learn.microsoft.com/en-us/azu...
How to do more with less in Azure SQL Managed Instance?: https://techcommunity.microsoft.com/t...
2022 - a year of unparalleled innovation in Azure SQL Managed Instance: https://techcommunity.microsoft.com/t...
Tutorial: Add SQL Managed Instance to a failover group: https://learn.microsoft.com/en-us/azu...