June 14, 2021 at 7:44 am
Hi Team,
We have primary DC which is having 3 nodes cluster and implemented AG setup on it.
We have AG with 3 replicas in primary DC.
now we want to setup DR .
My DR server is neither part or primary WSFC cluster nor separate WSFC cluster(it is like standalone server).
so i want to implement distributed availability group to replicate the data from primary DC AG to DR AG.
is there any possibility to setup DAG to standalone SQL Serevr ? I did not find any article how to setup this . please let us know if anyone is having info related this setup.
June 14, 2021 at 2:25 pm
You can set up an AG without a cluster in the DR DC. Then you can wire that up to a Distributed AG with the AG in your main DC. Follow the instructions for creating a 'read scale AG'. Failover will be manual only:
"Use read-scale with Always On availability groups" - https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/read-scale-availability-groups?view=sql-server-ver15
Eddie Wuerch
MCM: SQL
June 14, 2021 at 4:55 pm
Thanks Eddie Wuerch ... i will check and test this....
June 16, 2021 at 1:06 pm
Hi Eddie Wuerch,
can we use same listener name on primary and DR in DAG?
if both listener names are same we dont need to change app config setting to perform dr drill. so after failover no need to change anything in this case.Could you please advice?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply