Anyone have a list of all of the Log Shipping System Tables?

• Eric Peterson

  Hall of Fame

  Points: 3192

  More actions

  February 21, 2007 at 12:35 pm

  #116286

  I am getting an error from my log shipping LSAleart Job for a database that was deleted.   

  I did a manual cleanup of the system tables that I could find....but there must be one other that I am missing as I still get an error message that the system is out of synch for a database that dosent exist any more.

  The ones that I know about are located in the MSDB database 

  • log_shipping_monitor_alert
  • log_shipping_monitor_error_detail
  • log_shipping_monitor_history_detail
  • log_shipping_monitor_primary
  • log_shipping_monitor_secondary
  • log_shipping_primaries 
  • log_shipping_primary_databases
  • log_shipping_primary_secondaries
  • log_shipping_seoncdaries
  • log_shipping_secondary
  • log_shipping_secondary_databases

  What one last table am I missing?

  Eric

   

   

• Eric Peterson

  Hall of Fame

  Points: 3192

  More actions

  February 21, 2007 at 12:56 pm

  #691013

  Solved it as part of re-examining the issue.....double checking my tables... 

  Found the bad entry and removed the database from the Log_shipping_monitor_secondary table and the error went away.

  Love it when I solve my own issues.....too bad I had to post it first....lol

  EP