SQL 2000 Transactional Replication

  • Hi There,

    I have done validation and noticed that some tables are out of Synch with the Publisher. I copied the row difference into a temporary table, but I get the error below trying to run an INSERT INTO from the temp table to the Subscriber database tables: Any ideas please? (This process worked for a few other tables)

    I

    Server: Msg 30002, Level 16, State , Line 1

    Parent does not exist in "subscrip". Cannot create child in "back_issue".

    (where back_issue is the subscriber table name)

    FYI

    The subscriptions are initially synschronized using backup & resotore as stated in: http://support.microsoft.com/kb/320499,

    Replication is still operational at the moment.

    Topology: 1 Publisher, 2 subscribers (where one Subscriber is also the Distributor Server)

    Thanks.

  • You might get better responses if you post this in the 2000 forums. Currently this is posted in the SQL 2005 TSQL forums.

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

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