Friday 24 February 2012

Conflict table cleanup

Hello All -
Is there a process that automatically cleans the conflict tables?
I have a merge publication with publisher & distributer running on same
machine. This is SQL 2K and W2K host. The clients are push subscription.
I viewed several conflicts last week ( Friday) and postponed resolving them.
There were about 300 conflicts and I didn't view them all.
Today when I went to view them, EM told me that 'no conflicts table'.
Is there some automatic clean of the conflict tables?
Do conflicts get purged when re-initializing all client?
Thanks,
bruce
Yes we do cleanup the rows when the subscription is re-initialized, also
the conflict rows are deleted when we manually resolve it from the conflict
resolver.
thanks
gopal
|||Bruce,
This is not a cleanup, but a wipe out! Your problem could be related to the
fact that the Snapshot Agent may be running automatically.
Everytime this agent runs the conflict tables are dropped and recreated
(they say this is by design), therefore you will lose any conflicts that
were there before.
Raj Moloye

No comments:

Post a Comment