Post reply

Tran Replication returns error 2627

  • August 29, 2003 at 1:58 pm

    #76045

    I am having problems pushing a subscribtion when specifying - No, the subscriber already has the schema and data. Each time I try this I get the following error Violation of PRIMARY KEY constraint 'PK__@snapshot_seqnos__484E27E5'. Cannot insert duplicate key in object '#475A03AC'.

    (Source: MMSSQLQ1 (Data source); Error number: 2627).

    If I subscribe and intialize the schema and data, there is no problem.

    I apply changes to the publishing db and subscribing db and update the replication sp's also before sunscribing.

    Is there a setting I am missing?

    Any help would be great.

    Thanks.

  • September 1, 2003 at 8:00 am

    This was removed by the editor as SPAM

  • September 2, 2003 at 10:40 am

    #472219

    Not that I know of. It looks like you're out of sync somehow. Trying turning on the verbose logging for the distribution agent so you can some more details.

    Andy

    http://qa.sqlservercentral.com/columnists/awarren/

    Andy
    SQLAndy - My Blog!
    Connect with me on LinkedIn
    Follow me on Twitter

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply