Blog Post

Azure Database Support Blog
6 MIN READ

Setting up SQL Managed Instance Link to an Availability Group

SamGarth's avatar
SamGarth
Icon for Microsoft rankMicrosoft
Jan 10, 2025

We will go through an example to ensure an AG failover does not break MI Link.

On a recent case, a customer was trying to set up SQL Managed Instance Link to partner with an on premise Always On Availability Group (AG). Using the public documentation will work, but this will on...
Updated Jan 06, 2025
Version 1.0
always on
managed instance link
sql
sql managed instance
SQL MI
SQL MI Link
mario_lottering's avatar
mario_lottering
Copper Contributor
Apr 29, 2025

This guide is out of date.. Probably needs to look like this or something similar:

New-AzSqlInstanceLink -InstanceName $ManagedInstanceName -Name $DAGName -PartnerAvailabilityGroupName $AGNameOnSQLServer -ResourceGroupName $ResourceGroup -InstanceAvailabilityGroupName $AGNameOnSQLMI -PartnerEndpoint $SourceIP -Database $DatabaseName