I want to setup a topology for replication.

The scenario is such that a subscriber is subscribed to transaction replication based publisher (distributor running on publisher).

I then want this subscriber to be a publisher to another subscriber. I want the distributor to be on publisher instance (push).

Can some body help me out?


Yes, you can achieve the goal and implement replication topology. What I understood from your requirements is depicted in the diagram.

enter image description here

To do this follow these steps:

  1. Enable distribution on Server 1.
  2. Create replication, add articles and choose server 1 as publisher and server 2 as subscriber.
  3. Once articles are replicated, enable distribution on server 2.
  4. Follow step 2 for servers 2 and 3.

Your Answer

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

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