Log shipping error in Event Viewer - Out of Sync
Hello there,
I have a log shipping between my production db and report server. Both the DB are 2008R2. The schedule is as follows
BAckup - 9.30 to 17.30 Every 2 hours
Copy - 9.40 to 17.40 Every 2 hours
Restore - 9.45 to 17.45 Every 2 hours
But for some reason I get this error in the Event Viewer of the OS. The log shipping is taking place, i mean the report DB is getting updated every two hours too.then why this error
cheers
Zolf
I have a log shipping between my production db and report server. Both the DB are 2008R2. The schedule is as follows
BAckup - 9.30 to 17.30 Every 2 hours
Copy - 9.40 to 17.40 Every 2 hours
Restore - 9.45 to 17.45 Every 2 hours
But for some reason I get this error in the Event Viewer of the OS. The log shipping is taking place, i mean the report DB is getting updated every two hours too.then why this error
cheers
Zolf
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I have a schedule for the Copy as pointed in that article and my schedule is like so
BAckup - 9.30 to 17.30 Every 2 hours
Copy - 9.40 to 17.40 Every 2 hours
Restore - 9.45 to 17.45 Every 2 hours
I have given 10 mins break between backup and copy as you can see above or am i missing something,please bear with me.
BAckup - 9.30 to 17.30 Every 2 hours
Copy - 9.40 to 17.40 Every 2 hours
Restore - 9.45 to 17.45 Every 2 hours
I have given 10 mins break between backup and copy as you can see above or am i missing something,please bear with me.
Double check the schedules since the error is pointing to 45 minutes and not 2 hours for the Restore.
I'm assuming that 10 minutes is more than enough for the transaction log backup so 5 minutes should also enough for the copy process, right?
I'm assuming that 10 minutes is more than enough for the transaction log backup so 5 minutes should also enough for the copy process, right?
ASKER
Here are the screenshot for the 3 task i,e. Backup,Copy and Restore. Please have a look and let me know what I am doing wrong and what I need to change to get rid of that error.
Can't say much by the screenshots.
Just to confirm, do you have any other Transaction Log backup job scheduled out of the Log Shipping process?
Just to confirm, do you have any other Transaction Log backup job scheduled out of the Log Shipping process?
ASKER
No
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER