Post reply

Distributed Availability Group setup for DR Standalone SQL server

  • June 14, 2021 at 7:44 am

    #3895835

    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.

     

     

     

    • This topic was modified 3 years, 5 months ago by  dastagiri16.
    • This topic was modified 3 years, 5 months ago by  dastagiri16.

  • June 14, 2021 at 2:25 pm

    #3895966

    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

    #3896036

    Thanks Eddie Wuerch ... i will check and test this....

  • June 16, 2021 at 1:06 pm

    #3896973

    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?

     

    • This reply was modified 3 years, 5 months ago by  dastagiri16.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply