Replication Issue !! Need Urgent help!!

• Database admin(DBA)

  SSCertifiable

  Points: 5373

  More actions

  February 23, 2017 at 1:12 pm

  #335255

  Hi All,

  I have noticed following error message in the replication monitoring and when i checked it on Subscriber  server Foreign key doesn't exist on the DB,
  Can you please suggest me how to troubleshoot this issue further
  In other words.publisher server-- 1PK and 10FK...Publisher and distributor in same server
  but subscriber server 1 PK there is no FK on the table.

  Error messages:
  There is already an object named 'FK_Test_tab1'  in the database. (Source: MSSQLServer, Error number: 2714)

  Thanks in advance!!

  Best Regards,
  Reedy

  SQL server DBA

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  February 24, 2017 at 2:57 am

  #1930106

  Is reinitialising the subscription an option for you?  It might be easier than fiddling about trying to identify primary and foreign key constraints.

  John