0

My plan is i have One dedicated server for Transactional replication as subscriber. And two nodes in Availability Group. I want to replicate one availability database on primary as publisher. When there is automatic failover, the secondary node will become primary and continue the transactional replication to dedicated server. Is there any way to achive this plan?

1 Answer 1

0

Suggestion:

  1. Make sure that all secondary replicas in the AG are setup with synchronous commit, with automatic failover.
  2. Have the replication agents connect with the listener of the AG.

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.