log shipping meta data does not update.

• baby_cheeses

  Old Hand

  Points: 355

  More actions

  April 22, 2010 at 7:10 am

  #218153

  I have this really annoying problem.

  I've had to reconfigure log shipping for a no. of dbs. I have 3 distinct servers, prim, 2ndary, monitor.

  I unchecked log shipping from the primary db, checked all meta data was deleted from all, checked jobs were deleted, rebacked up, restored & reconfigred log shipping. The backup job worked fine. @ 1st the copy job failed.

  I noticed missing meta data from monitor & 2ndary & inserted this - not ideal, but I've tried this many many times now via SSMS.

  Now, the jobs all work BUT, on the monitor server & 2ndary, the last copied file / date & last restored file / date fields in the log shipping tables (that I inserted, leaving these fields as null), doesn't update.

  Any ideas?

  Prob tables are:

  mon:

  log_shipping_monitor_secondary

  2ndary:

  log_shipping_monitor_secondary

  log_shipping_monitor_secondary_databases

  Open to ANY ideas!!

  Thank you.

• Rong Li-358540

  Grasshopper

  Points: 19

  More actions

  March 5, 2012 at 11:08 am

  #1454924

  did you resolve your problem? I have the same issue