Solved

Conflict Resolution for Merge Replication

Posted on 2011-03-17
2
411 Views
Last Modified: 2012-05-11
All,

I had my first conflict detection with our merge replication setup.  I queried the msmerge_conflict_publicationname_aspolicy table in both publisher and subscriber and found the record that was the loser? This setup is a client subscription (with first to publisher wins).  So the record that "won" was the correct one.

My question is that when I selected to "remove/delete" the conflict from the Conflict GUI, it only removed the conflict record in the publisher table (msmerge_conflict_publicationname_aspolicy); the subscriber msmerge_conflict_publicationname_aspolicy still has the record.

I had to disable my conflict alert I setup b/c this record still exists in the subscriber; I thought that when I "removed/delete" the conflict it would remove the record in both places, but that is not the case.  When I renabled the alert (that monitors conflicts) it still send me an email telling me there is a conflict.

Can someone let me know what needs to be done here?
0
Comment
Question by:jwa082276
2 Comments
 
LVL 20

Expert Comment

by:Marten Rune
ID: 35164081
0
 
LVL 10

Accepted Solution

by:
TAB8 earned 500 total points
ID: 35168401
Sometimes replication dosent tidy up after its self very well in the repl sys tables
what you could do to fix this quickly is :
1, stop user access to both pub/sub "no data changes
2, from the sub server delete the subscription
3, on the sub server run sp_removedbreplivation 'databasename'  "this will remove the repl sys tables"
4, create a new subscription to the publication and unselect the initialisie option "this will recreate the repl sys tables but wont reimport all the data so dosent take long"

0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now