Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    1

    Unanswered: Error in Replication how to continue

    I have transactional Replication from A to B.

    My distribution agent failed becos of a primary key violation error in a table.[i have not included the skip error option].

    Then the replication stopped.
    The transactions on other tables are also not replicated to B.

    IF an error is encountered in one of the tables will the replication stop entirely??.Is there no way for the replication to continue for the rest of the tables..
    Pls clarify

  2. #2
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311

    Re: Error in Replication how to continue

    I don't think you can skip this error. To use Replication you have to have a primary key in the table you want to replicate.

  3. #3
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    The transactions are processed in a serialized fashion, meaning that if one failed nothing else goes through.

Posting Permissions

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