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.
Prob tables are:
Open to ANY ideas!!