Advice on AG DR setup

Question

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

Answer 1

Hi @Samantha r ,

>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

Answer 2

Hi @Samantha r ,

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/

Answer 3

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