Groups | Blog | Home
all groups > sql server replication > january 2006 >

sql server replication : Laptop subscription conflicts



David
1/26/2006 4:46:25 PM
We are having some data conflicts with some laptops that have "timed out"
and not finishing a synch. Once they are successful, will these conflicts
resolve themselves? For example one of the conflicts is due to a FK/PK
problem because (I think) that one of the tables did not get synched and the
failing one had records in it that related to that table. Is this possible?
Thanks.

David

Hilary Cotter
1/26/2006 9:12:20 PM
Conflicts are always resolved. The winning row gets entered in the database,
the loosing row gets entered in the conflict tables.

The are always resolved - but perhaps not in the way you like:) Normally the
next time the agent will run the missing rows should be carried over. Note
that you will have to put the Not For Replication clause on all constraints
for this to happen.

--
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

[quoted text, click to view]

AddThis Social Bookmark Button