I have a production system: Transactional Replication
Server A (Publisher)
Server B (Distributor, Subscriber)
Now I got a new Server C
Server C should also subscribe the publication to server A
But the distribution Database is on Server B.
I want that every subscriber has it's own distribution database.
I made a 2nd publication on server A and made a distribution on server c,
But Server A talks only to distribution on server B. and I think that could be a performance and
availability problem, because everything goes over server B
Have you any ideas?
My wish configuration:
Server A: Publication for Server B
Publication for Server C
Server B: distribution B, Subscriber
Server C: distribution C, Subscriber
Please Help ME