Hi all,
I have a problem with "Updatable Subscriptions" under concurrent transactions on both pub and sub effecting same data. At high level of concurrency it Subscriber starts giving error msg "Rows do not match between Publisher and Subscriber. Run the Distribution Agent to refresh rows at the Subscriber.".Please tell me any way arround for this.
Quick question: how much update are you doing on your subscriber and how frequent?
Here is a direct quote from BOL http://msdn2.microsoft.com/en-us/library/ms152570.aspx
The following types of replication and replication options allow you to make changes at a Subscriber and have those changes flow to the Publisher:
Merge replication
There are a large number of Subscribers.
Data is replicated to mobile users.
Replicated data is frequently updated at the Subscriber.
Data filtering is needed so that Subscribers receive different partitions of data.
|||There was also a recent QFE fixed to address a similar issue, but like Gary said, it depends on how frequently you're updating the same data at both ends. The QFE fix will make it into SP2, but if you need the fix immediately, you can call CSS.|||Thank you for help i wll go with peer to peer replication
No comments:
Post a Comment