Solved

Conflict Resolution for Merge Replication

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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
This video discusses moving either the default database or any database to a new volume.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

760 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

20 Experts available now in Live!

Get 1:1 Help Now