Post reply

Transactional Replication (SQL 2000, SP4)

  • February 19, 2008 at 7:57 am

    #203559

    Hi,

    Data validation reported that tables are out of Synch with the Publisher. I copied the row difference into a temporary table(using t-sql), but I get the error below trying to run an INSERT INTO from the temp table to the Subscriber database tables:

    Any ideas or recommedation please? (This process worked for a few other tables)

    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 & restore 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), Push subscription.

    Thanks.

  • February 28, 2008 at 1:11 am

    #783025

    Hi,

    Does that error occur after you've inserted the data at the subscriber end and attempt to run the ditribution agent?

    Are all these tables you've done this with part of the same publication?

    Were the tables all synchronised before you put the replication in place i.e. after the restore?

    Regards

    Graeme

  • February 28, 2008 at 10:39 am

    #783358

    Thanks for your reply Graeme.

    No, am unable to insert the data at the subscriber. Infact the distribution agent failed initially and I have had to use skip error to keep replication operational, while I find a solution.

    All the tables where in synch as it was restored from the publisher with no data input to the database until replication was setup.

    The tables in question are all from the same publication. The Publisher database is published twice with 2 separate publications, both containing different articles.

    The first publication named A has all it's articles in synch, but the 2nd publication B is the one with the problem, majority of the tables are out of synch.

    I am trying to resolve this without having to drop the publication.

    Any ideas please?

  • February 29, 2008 at 12:35 am

    #783626

    Hi,

    By querying the MSreplication tables in the distribution can you determine what commands are waiting to be applied by the agent?

    Graeme

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

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