Saturday 25 February 2012

Conflicts table

Is is safe to delete the records in the conflict_ table for a merge
replication?
I have a lot of conflicts logged there that I just don't care about (I would
like to not record the conflict to start, but i think that's not possible).
Can I just delete the records?
Thanks, Jos Araujo.
These are purged IIRC after the retention period. It is safe to delete them,
but I would not do it - just cause I hate to mess with replication innards.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Jos Araujo" <josea@.mcrinc.com> wrote in message
news:uDDhNHTCFHA.3376@.TK2MSFTNGP12.phx.gbl...
> Is is safe to delete the records in the conflict_ table for a merge
> replication?
> I have a lot of conflicts logged there that I just don't care about (I
would
> like to not record the conflict to start, but i think that's not
possible).
> Can I just delete the records?
> Thanks, Jos Araujo.
>
|||Great... thanks for the answer.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:uS09OCWCFHA.1524@.TK2MSFTNGP09.phx.gbl...
> These are purged IIRC after the retention period. It is safe to delete
them,
> but I would not do it - just cause I hate to mess with replication
innards.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Jos Araujo" <josea@.mcrinc.com> wrote in message
> news:uDDhNHTCFHA.3376@.TK2MSFTNGP12.phx.gbl...
> would
> possible).
>

No comments:

Post a Comment