Restoring replicated database

• Randy Yates

  SSC Enthusiast

  Points: 126

  More actions

  October 3, 2005 at 1:45 pm

  #89557

  One of the developers asked me to backup our master replication database. He made a change and then asked me to restore the database to undo his changes. Following the full recovery of the one user database (system databases not recovered) I am getting the following log reader agent error "The LSN (4146:28119:1) passed to log scan in database '<My user db name>' is invalid." What is the resolution to fix replication?

• Graeme100

  SSCrazy Eights

  Points: 8054

  More actions

  October 6, 2005 at 1:50 am

  #595350

  I think you may have to re-apply replication to this restored database...re-subscribe or re-publish.

  The logreader is probably referring to the pre-restored version.

  Reapplying the rep will set up a new logreader

  HTH

  Graeme