Advice on AG DR setup

Sam 1,416 Reputation points
2020-12-29T08:08:45.943+00:00

Hi All,

Need some advice for setting up remote DR setup.

Current we have below AG setup and we are using SQL Server 2017 Enterprise Edition.

We have a 2 node primary and secondary replica's AG configuration in one region USWest in one subnet.
We have a single node for DR which is a different region USEast which is resided in another subnet.

What are the options we can have to add the 3rd node which is in different subnet to AG? we want to configure it as DR site.

Regards,
Sam

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,120 questions
0 comments No comments
{count} votes

Accepted answer
  1. Cris Zhan-MSFT 6,611 Reputation points
    2020-12-31T02:19:43.69+00:00

    Hi @Sam ,

    >The 3rd node is not in the same domain. Does traditional log shipping work ?

    Setting up the log shipping across domains is supported, and you can setup Log-Shipping on Database part of Always On Availability Groups.

    If computers that are running SQL Server are placed in a multi-domain environment, Microsoft recommends that you set up two-way trusts between all domains that are involved in log shipping. However, if you cannot establish trusts between domains, you can use network pass-through security for log shipping.
    https://learn.microsoft.com/en-us/troubleshoot/sql/log-shipping/configure-security-log-shipping

    1 person found this answer helpful.

2 additional answers

Sort by: Most helpful
  1. Cris Zhan-MSFT 6,611 Reputation points
    2020-12-30T04:28:30.967+00:00

    Hi @Sam ,

    Please refer to following article that may fit your scenario.
    First Add this 3rd node to the existing WSFC. This means the 3rd node should be added to the same active directory domain.

    https://www.mssqltips.com/sqlservertip/4598/add-secondary-replica-to-existing-sql-server-alwayson-availability-group/

    1 person found this answer helpful.

  2. Anshul Farkya 131 Reputation points
    2020-12-30T07:51:31.997+00:00

    After adding 3rd node in WSFC, you need to create a load balancer in Azure for configuring SQL listener name with required probe ports and IP addresses.

    Below link is having all details for same:
    https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/availability-group-manually-configure-tutorial

    Thanks,
    Anshul

    1 person found this answer helpful.
    0 comments No comments