October 11, 2023 at 5:46 pm
My prod is already part of the Always On Availability Group in On-Prem then Azure SQL Managed instance link to SQL MI will not work. So what would be the other options to work something like similar to Azure SQL Managed instance link which is close to real time and it has feature from SQL 2022 failover/failback to SQL MI. Any thoughts?
October 12, 2023 at 8:05 am
SQL MI Link uses DAGs instead of AG's to extend your on-prem AG to SQLMI.
If you're attempting to extend the AG normally like you would with just adding a replica that wont work.
You need to build a new AG on the SQLMI then link the On-Prem AG to the SQLMI AG using a DAG.
October 12, 2023 at 5:56 pm
Can you able to create AG on SQL MI which is PAAS service in Azure.
October 12, 2023 at 6:45 pm
Check the documentation on the setup and ensure that the features you are after using are actually generally available, otherwise you may need to use public preview
Failback is a preview option at the moment.
October 12, 2023 at 8:45 pm
I can able to setup up replication from Standalone On prem SQL Server to SQL MI using Managed instance link. But when the On prem database is already part of Always on Availability group then you wont able to use Azure Managed Instance Link.
October 13, 2023 at 8:07 am
The Managed Instance link feature uses distributed availability groups to extend your SQL Server on-premises Always On availability group hosted anywhere to Azure SQL Managed Instance in a safe and secure manner, replicating data in near real-time.
If it doesn't work, then raise a ticket with MSFT and ask them why not, the docs say you can extend your on-prem AOAG to SQL MI using a DAG.
Get them to tell you what you have missed.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply