Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002

    Unanswered: Data Lost-Merge Replication

    We are using merge replication over internet to repliacte our data b/w 2 servers located at 2 different branch offices. But the strange thing is we are losing data i.e. data is being automatically deleted during replication.

    any idea/help for fixing it would be hihgly appreciated

    thank in advance

  2. #2
    Join Date
    Jan 2003
    Nottinghamshire, UK
    Probably failed insert at subscriber poss due to Referential Integrity Failure.

    Because SQL Must make publisher & Subscriber with same data it will come back & delete publisher row

    Keep an eye on the conflicts
    "Everything should be made as simple as possible, but not simpler." - Albert Einstein
    "Everything should be made as complex as possible, so I look Cleverer." - Application Developer

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts