November 28, 2011 at 4:36 am
The log shipping secondary database secondaryserverip\database has restore threshold of 45 minutes and is out of sync. No restore was performed for 235 minutes. Restored latency is 40 minutes. Check agent log and logshipping monitor information
The bakcup server rebooted, after that i am gettgin restrore job error , backup job running normally.
Please help me
thanks
jery
November 28, 2011 at 4:42 am
manually copy the .trn files into secondary(stand by) server which are not copied in stand by server and run the restore job.
November 28, 2011 at 4:55 am
check your standby server is copying and restoring the logs?
is the SQL Server and/or Agent online after the reboot?
are the services set to automatic startup? if not set to auto.
have the service account passwords expired and cannot start?
have you given new service account to the agent? does this account have access to the UNC path to copy the TRN files?
can you log on as the service account and browse the UNC path to rule the above out?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply