We have 2 AlwaysON cluster and we want that to set up as a SQL Replication server which is the Always-on Cluster 1 is the Publisher and Always-on Cluster 2 is the SUBSCRIBER, my question is it possible to set up the subscriber which is in an AlwaysON setup? Do I need to configure both nodes as a subscriber? Please give me an idea how to execute that setup

  • There's some pretty thorough documentation on the topic. You'll just need a separate server to be dedicated as a distributor – AMtwo Aug 6 at 5:46
  • Yes it's possible. We have WFCI-cluster-Publisher > separate distributor > AG-cluster-Subscriber (using Listener instance name) – Jerry Hung Aug 6 at 6:58
  • @AMtwo yes, I dedicate 1 server for distributor, my problem is a client want the Subscriber is in AlwaysON setup. – GoodGuyChaddy Aug 6 at 7:48
  • @JerryHung do I need to set up 2 nodes as Subscriber or using AG Listener IP only? – GoodGuyChaddy Aug 6 at 7:49
  • @GoodGuyChaddy only AG listener IP (or we used Alias mapped to IP) – Jerry Hung Aug 7 at 8:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.