Replication Error

We have a merge replication setup among seven servers. I have found some replication issue, mainly mismatch data between Publisher and 2 subscriber. I also noticed that merge agent at subscriber was stopped & started. Now the data is not getting synchronized among those 2 subscriber and the publisher. I checked the Replication Monitor, Replication cannot get past the ‘connecting to subscriber “X”’ message.

Now i need to synchronize the data, before doing that i thought to get a second opinion from you guys. Since i don't want to have any data loss at the subscriber or at publisher, so i cannot reinitialize the synchronization. My options are - track out mismatch records using tablediff and do a manual delete insert at the publisher. Another option is to use Redgate SQL Data Compare, and synchronize tables on both publisher and subscriber.

Please guide me if am wrong at any point or if there are many other better option available.

more ▼

asked Feb 13, 2011 at 10:09 PM in Default

avatar image

10.8k 37 58 51

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Using Redgate SQL Data Compare could be a good idea, but remember that you will need a decent connection between the two servers as a lot of data may need to flow.

You can also tell a subscriber to reinitialise and upload changes to the publisher first. When you try to initialise through the GUI the question pops up

alt text

more ▼

answered Feb 13, 2011 at 11:57 PM

avatar image

26.2k 18 38 48

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Feb 13, 2011 at 10:09 PM

Seen: 1017 times

Last Updated: Feb 13, 2011 at 10:09 PM

Copyright 2018 Redgate Software. Privacy Policy