Post reply

Pull replication failed right after rebuild index

  • July 29, 2003 at 5:41 am

    #80920

    We set up pull reblication, and every time the date of our rebuild idnex job start then log reader agent will failed, we have backup log before reindex and rebuild index then backup log, after this job started, no more record start replication, and around 10 time retry then will page us replication failed, and if we diabled this job and our replication will not fail.

    Any idea?

    feifei liu

    feifei liu


    Rachel

  • July 29, 2003 at 10:11 am

    #467524

    Wich type of replication? Transactional?

  • August 6, 2003 at 11:30 am

    #468873

    Yes it is transactional pull method

    feifei liu


    Rachel

  • August 6, 2003 at 1:43 pm

    #468878

    You might need to increase the timeout on the logreader. Rebuilding requires a lot of log entries and the reader has to process all of them even though they don't get replicated.

    Andy

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

    Andy
    Connect with me on LinkedIn

  • August 12, 2003 at 6:22 am

    #469540

    Actually when the reindex job I exclude that table 10 times retry and almost retry over 10 hour then failed then we got page?

    Any idea? Why ?

    Thanks

    feifei liu


    Rachel

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

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