Backup job failed to start
colby
Posts: 30
Need help.
Redgate 5.3 was used to set up jobs to perform hourly transactional backups on many servers. Worked great for weeks with no problems. When I came in from the weekend to check on progress, none of the hourly jobs on 3 servers were shown on the Redgate GUI. I could not tell if they failed or what happened!! I finally found that the Saturday midnight hourly backups was still running (I am checking Monday morning). None of the hourly transactional jobs ran for 1 1/2 days!.
1) Does the Redgate monitor know when jobs run so if it does not run I can be alerted?
2) Can I change the SQL job to alert me if the job does not start?
3) I tried killing the SPID in the job to to sucess on 2 servers but the SPID is shown to be rollback -- for 6 hours. What can I do to kill the job start the hourly transactional? What are my options to start the backup hourly transactional log.
Thanks
Colby
Redgate 5.3 was used to set up jobs to perform hourly transactional backups on many servers. Worked great for weeks with no problems. When I came in from the weekend to check on progress, none of the hourly jobs on 3 servers were shown on the Redgate GUI. I could not tell if they failed or what happened!! I finally found that the Saturday midnight hourly backups was still running (I am checking Monday morning). None of the hourly transactional jobs ran for 1 1/2 days!.
1) Does the Redgate monitor know when jobs run so if it does not run I can be alerted?
2) Can I change the SQL job to alert me if the job does not start?
3) I tried killing the SPID in the job to to sucess on 2 servers but the SPID is shown to be rollback -- for 6 hours. What can I do to kill the job start the hourly transactional? What are my options to start the backup hourly transactional log.
Thanks
Colby
Comments
No. The issue was not because the job did not start, but because the previous job did not end.
It's strange that killing a backup job should result in a rollback. Could you please run the following command on the affected servers, and send me the SQBCoreService_bugreport.txt file that is generated in the folder where the SQL Backup Agent service (SQBCoreService.exe) is installed?
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8