Conflict between msdb.restorehistory and log_shipping_plan_history tables

• fssherwani

  Old Hand

  Points: 365

  More actions

  April 25, 2007 at 9:26 am

  #119837

  Hi Folks -

  I have a situation in which my log shipping monitor and restorehistory table have conflicting entries.

  The log_shipping_plan_history table have entry error 4305 for restore operation but when i query restorehistory it logs successful restore operation BUT the backup_set_id is same since 4:00 pm yesterday.

  Our log shipping backups;copies and restores the files every 5 minute to the secondary server.

  Any help/comments are welcome.

  Fahad

• homebrew01

  SSC Guru

  Points: 55548

  More actions

  December 6, 2007 at 12:40 pm

  #757831

  Did you ever figure it out ?? I have a similar problem.