How does provide replication for one server from multiple instances?

  • I'm database developer. For one of the MS SQL project we testing SQL Service Broker replication. Basically we need to replicate table changes from multiple initiators to one target.

    We implemented environment according to the article:

    http://www.sqlteam.com/article/centralized-asynchronous-auditing-across-instances-and-servers-with-service-broker

    When we setup 1 initiator - it works fine, messages are sent and processed . But when we configure second initiator, it sends only the first message, which is preserved in sys.transmission_queue () and all new messages just sit in sys.transmission_queue without processing. No transmission errors is in sys.transmission_queue on 2-nd initiator. It seems that acknowledgment about message delivery and processing on target can't reach 2-nd initiator.

    1-st initiator uses service like tcp://192.168.2.130:4022/vpiCore/Audit/DataSender

    2-nd initiator uses service tcp://192.168.2.116:4022/vpiCore/Audit/DataSender

    Route on target is configured as TRANSPORT

    Could you help us to resolve the problem, any feedback is highly appreciated, especially GOOD EXAMPLE or link

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply