Post reply

Count Mismatch between Publisher and Subscriber

  • July 6, 2009 at 4:31 am

    #211822

    Hi,

    The recound count mismatch between Publisher and Subscriber. There is no error recorded in MSrepl_errors and no red cross in Replication Monitor.

    All agents are working fine. Not sure where to look, Please help!!!

    Publisher - 2000 SP4

    Local Distributor -- 2000 2000 SP4

    two subscribers -- 2005 SP1 and SP2

    Plublisher has more records then subscriber. And subscribers record count is same.

    Deepak

  • July 6, 2009 at 5:19 am

    #1020289

    Run the jobs related to transaction Replication again ( synchrnozie via replication monitor) in sql agent jobs but do not reinitialize.

    ssuresh rajan.

  • July 6, 2009 at 7:04 am

    #1020333

    Hi,

    I can see the distributor has received the commands

    select * from msdistribution_status s join msarticles a on s.article_id = a.article_id and UndelivCmdsInDistDB >

    but subscriber is not pulling it. Restarted the Distribution agent but data is not replicated for this Publication

  • July 6, 2009 at 7:10 am

    #1020338

    Can u also check if the tran log file of the subscriber is full(if its in full recovery mode?)


    Pradeep Singh

  • July 6, 2009 at 7:30 am

    #1020357

    Hi,

    DB is in Simple revoery mode, plus has enough free space on log file.

    Deepak

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

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