Post reply

Error after restoring publication database in replication

  • March 29, 2010 at 1:37 pm

    #139966

    Hi,

    Please find below error on restoring publisher database in SQL server.

    Please share reason for this error message and kindly suggest workaround for brining replication running again

    Error Message in REPL-LogReader Job

    2010-03-29 19:04:14.538 Status: 0, code: 20011, text: 'The process could not execute 'sp_repldone/sp_replcounters' on 'server'.

    2010-03-29 19:04:14.538 The process could not execute 'sp_repldone/sp_replcounters' on 'server'.

    2010-03-29 19:04:14.538 Status: 0, code: 9003, text: 'The log scan number (37:396:4) passed to log scan in database 'dbname' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup. '.

    2010-03-29 19:04:14.538 Status: 0, code: 22017, text: 'The process could not set the last distributed transaction.'.

    2010-03-29 19:04:14.538 Status: 0, ode: 22037, text: 'The process could not execute 'sp_repldone/sp_replcounters' on 'server'.'.

    M&M

  • March 30, 2010 at 10:07 am

    #1142404

    If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup

    You might have to re-create the publication as indicated in error message.

    MJ

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

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