Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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:
mon:
log_shipping_monitor_secondary
2ndary:
log_shipping_monitor_secondary
log_shipping_monitor_secondary_databases

Open to ANY ideas!!

Thank you.



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

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, May 06, 2013 10:55 AM
Points: 1, Visits: 116
did you resolve your problem? I have the same issue
Post #1261729
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse