Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Location
    Bangalore, India
    Posts
    27

    Unanswered: Replication Error...

    I have a SQL server which has the databases installed with transactional replciation enabled. I got an error which is mentioned below in my distribution agent history :-

    Violation of PRIMARY KEY constraint 'PK__@snapshot_seqnos__3647D946'. Cannot insert duplicate key in object '#3553B50D'.

    Violation of PRIMARY KEY constraint 'PK__@snapshot_seqnos__3647D946'. Cannot insert duplicate key in object '#3553B50D'.
    (Source: FLORA\INSTANCE1 (Data source); Error number: 2627)
    ------------------------------------------------------------------------------------

    Can anyone let me know the reason for the above mentioned error???



    Thanks,
    Santhosh.C.

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

    Re: Replication Error...

    Your subscriber is not in sync with your publisher. If the database is not too big or you can shut down the app, go ahead and reinitialize the subscription to sync the replication.

Posting Permissions

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