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
Last activity: Apr 20, 2024, 12:32 PM