Blog Post

Azure SQL Blog
5 MIN READ

How-to test failover group connectivity between primary and secondary SQL Managed Instances

NikoNeugebauer's avatar
NikoNeugebauer
Icon for Microsoft rankMicrosoft
Jan 12, 2022
This blog post is one of the 2 posts in the tiny SQL Managed Instance series on how-to determine the status of the connectivity from inside the Azure SQL Managed Instance. They will help you to deter...
Updated Nov 04, 2022
Version 9.0
Phaneendra's avatar
Phaneendra
Copper Contributor
Jul 03, 2026

Testing connectivity between the primary and secondary region is simple to find whether the SQL MIs are in sync. The current blog script had few errors in the commands, so I had documented the process in a blogpost available at https://cloudnerchuko.in/check-replication-status-between-sql-mi-primary-and-secondary/

It follows the same process, except the commands are verified and tested.