Sample Header Ad - 728x90

Can a SQL Server Distributed Availability Group have multiple secondary replica Availability Groups?

0 votes
1 answer
198 views
I have a question regarding the configuration of SQL Server Distributed Availability Groups (DAGs). I understand that a DAG is used to replicate data from one Availability Group (AG) to another. However, I'm curious about the possibility of having multiple secondary replica AGs for a single DAG. Specifically, let's say I have a Distributed Availability Group named "dag1". Is it possible for "dag1" to replicate data from a primary Availability Group "ag1" to multiple secondary Availability Groups, such as "ag2" and "ag3"? In other words, can a single DAG have a one-to-many relationship with secondary replica AGs? I would greatly appreciate if someone could clarify whether this configuration is supported and provide any additional insights or considerations when setting up a DAG with multiple secondary replica AGs. Thank you in advance for your help!
Asked by Just a learner (2082 rep)
Apr 20, 2024, 09:31 AM
Last activity: Apr 20, 2024, 12:32 PM