0

I currently have an AG with 2 replicas both running SQL Server 2016. These are both located on premise. I was looking to add a third node using a AWS EC2 instance and asynchronous replication.

Networking issues aside, is this an acceptable approach?

The only resources I can find on the internet appear to use distributed AGs but that would mean having a second EC2 instance in AWS

asked Mar 9, 2020 at 11:29

1 Answer 1

0

I assume it would be like this hybrid it: disaster recovery scenario but with AWS instead of Azure. There is an interesting point in the article about having your Active Directory available in the cloud.

I think you'd have to give some thought to how quorum would work. For example, what would happen if you did a manual failover to the cloud instance, then later your on-premises instances came back online?

HTH

armitage
1,4292 gold badges14 silver badges20 bronze badges
answered Mar 10, 2020 at 16:23

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.