Replication and Distributed Availability Groups Limitation

Share this Post

Currently Microsoft SQL Server Always Distributed Availability Groups does not support one global listener for the entire distributed AG. Replication in an Availability Group is currently is configured using a single Listener. Until either Distributed AGs support a single Listener or Replication support multiple Listeners, Distributed AG and Replication environments are not compatible. As improvements are made and technologies evolve, I believe one day we’ll overcome these limitations.

If the goal is to move data to a distributed environment, consider using a Replication Re-Publisher topology or simply have remote replica as Subscribers.

Another option is to move the entire solution to Azure SQL DB distributed cloud-based solution providing both scale-out and scale-up capabilities.

Chris Skorlinski
Microsoft SQL Escalation Services

Share this Post

About: ReplTalk

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.