log shipping meta data does not update.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Database Design » Disaster Recovery » log shipping meta data does not update.

log shipping meta data does not update.

Rate Topic

Display Mode

Topic Options

Author

Message

baby_cheeses

Posted Thursday, April 22, 2010 7:10 AM

Grasshopper

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

Rong Li-358540

Posted Monday, March 05, 2012 11:08 AM

Forum 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 »

Permissions