Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

log shipping meta data does not update. Expand / Collapse
Posted Thursday, April 22, 2010 7:10 AM


Group: General Forum Members
Last Login: Friday, November 19, 2010 8:59 AM
Points: 17, Visits: 49
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:

Open to ANY ideas!!

Thank you.

Post #908575
Posted Monday, March 5, 2012 11:08 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, November 9, 2015 12:51 PM
Points: 1, Visits: 131
did you resolve your problem? I have the same issue
Post #1261729
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse