0

I have a Windows failover cluster up and running, with a primary and secondary server.

I have also created an Always On Availability Group with the two servers, with both the primary and the secondary replica being synchronous replicas.

I now want to add an additional asynchronous replica to the Always On Availability Group; to do so, do I need to modify the Windows failover cluster?

1
  • Why the downvote?
    – Foo
    Aug 15, 2022 at 21:30

1 Answer 1

2

I now want to add an additional asynchronous replica to the Always On Availability Group; to do so, do I need to modify the Windows failover cluster?

Depends on how you want to do it. If you're adding an instance on another server, then that other server must be added to the WSFC in your current deployment as AGs can't span differing clustering environments.

If you don't want HA but DR/BC, then it's possible to not use a cluster by using read-scale AGs, which do not require clustering.

12
  • Thank you for your reply. I've added the third asynchronous replica to the always on availability group but I see it's in a disconnected state. Is this to be expected then, since it's not part of the failover cluster?
    – Foo
    Aug 15, 2022 at 19:45
  • 1
    If it's not part of the cluster it's not even supported to run properly, let alone anything else. @Acuriousmind Aug 15, 2022 at 19:56
  • Right, so the server has to be part of the failover cluster?
    – Foo
    Aug 15, 2022 at 20:00
  • If you don't want HA but DR/BC, then it's possible to not use a cluster by using read-scale AGs could you please expand on how I could do this?
    – Foo
    Aug 15, 2022 at 20:02
  • 1
    learn.microsoft.com/en-us/sql/database-engine/… @Acuriousmind Aug 15, 2022 at 20:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.