July 27, 2016 at 1:13 am
Hi Everyone,
I configured Log shipping and Backup job running fine by placing the backup files at respective location. The Copy and Restore jobs on Secondary server are not performing well, but these jobs getting successful (status showing "Success") and when I run these jobs manually, then we could see Primary Database backup file copied to respective location and log backup restored on Secondary database. Does these jobs having delay to copy backup file and restore onto Secondary server?
Can I have a reason why Copy and Restore jobs are not performing (as per schedule where as status shows "Success") and performing well only manually please?
As I cannot run two jobs every time to continue with Log shipping, please give me a solution for the jobs to run successful as per schedule.
July 27, 2016 at 8:22 am
I am not sure I understand the problem. Did you check the schedules of the various jobs? That has been the thing that most of my clients don't understand.
If the jobs are failing, what is the error message for the job?
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
July 29, 2016 at 10:01 am
Check the job history and post details of any issues it raises.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply