Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How does provide replication for one server from multiple instances? Expand / Collapse
Author
Message
Posted Wednesday, March 30, 2011 2:07 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 08, 2011 8:27 AM
Points: 1, Visits: 5
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
Post #1086026
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse