SQLTeam.com | Weblogs | Forums

Facing an error in logshipping


#1

Hi,

I'm facing an error in logshipping.

Unfortunatly logshipping got disconnected @ 28th Sep 2015 11:30AM, but still the backup job and Copy job is running perfect(up to now), only the restore job is not working(even if i start the restore job manually its showing as success).

Initially Logshiping type : Standby/Readonly mode
currently the secondary db : restoring mode

Is there any way to resolve with out reconfigure the logshipping from the base?

Error description:

The log shipping secondary database %s.%s has restore threshold of %d minutes and is out of sync. No restore was performed for %d minutes. Restored latency is %d minutes. Check agent log and logshipping monitor information.

Thanks in advance,
Vignesh R


#2

When you look at the "Transaction Log Shipping Status" default report check the filenames at the right. if those are all the same then up to date.

Since you are still showing out of threshold are you getting any error saying it cannot find a file or log file is out of sync?

When you run the job manually does it actually do anything (see report)?

Have you run a manual transaction log backup on the database?