x

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

Cyborg gravatar image

Cyborg
10.6k 36 40 45

(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][1]

[1]: /upfiles/Capture_1.PNG
more ▼

answered Feb 13, 2011 at 11:57 PM

WilliamD gravatar image

WilliamD
25.9k 17 19 41

(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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x305
x23

asked: Feb 13, 2011 at 10:09 PM

Seen: 793 times

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