September 28, 2011 at 6:01 am
Hi Team,
I have configured Logshipping. But the Backup job was failed it is giving below error can you any body please suggest me.
Log Job History (xx)
Step ID 0
Server xx
Job Name xxC
Step Name (Job outcome)
Duration 00:00:13
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
The job failed. The Job was invoked by Schedule 2473 (xx). The last step to run was step 1 (Log shipping backup log job step.).
The log shipping secondary database has restore threshold of 45 minutes and is out of sync.
No restore was performed for 1187 minutes. Restored latency is 0 minutes. Check agent log and logshipping monitor information.
and I have checked in agent log also but no use any body please help me.
Tx
September 28, 2011 at 9:31 am
you will need to provide history details of the LS backup job from the primary server.
The history you have posted indicates that the secondary database restore threshold has been reached. Have you tried manually copying the log backups to the secondary and manually restoring each one in turn.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 29, 2011 at 4:14 am
Hi Team,
Thank you for your support
I have given wrong path it is completed.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply