Solved

Conflict Resolution for Merge Replication

Posted on 2011-03-17
2
412 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

827 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