1

I have query regarding "AlwaysOn Availability Groups with Replication Subscribers"...

  1. Can I add multiple publishers to a subscriber(which is part of availability group as a primary server)?
  2. In which node can I configure distributer?
  3. How do I configure the distributer?
Improve this question

1 Answer 1

Reset to default
1

Can I add multiple publishers to a subscriber(which is part of availability group as a primary server)?

Yes, this is the multiple publishers model and is supported.

In which node can I configure distributer?

The distribution database is currently not supported for use in AlwaysOn Availability Groups. The only supported method for transparent distributor failover is AlwaysOn Failover Cluster Instances.

How do I configure the distributer?

You can configure it through SSMS or T-SQL.

Improve this answer
2
  • thanks for reply...but answer of my second question is not satisfied my scenario..yesterday i successfully configured "AlwaysOn Availability Groups with Replication Subscribers"...and its running good..i configured distributer for replication on subscriber box(primary replica) and issue is after failover my primary replica goes down and also distributer ...so my question is where to configure distributer for replication....
    – Gulrez Khan
    Commented Jun 28, 2016 at 5:24
  • If you want HA for the distributor, put it on its' own FCI instance. Make it a VM, pretty much do anything but I would not put it on an instance using Availability Groups.
    – Sean Gallardy
    Commented Jun 28, 2016 at 5:43

Your Answer

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

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