I've had log backup jobs fail for a few different reasons lately. When I go to the job it tells me backup terminated abnormally. However, when I run the backup script in SSMS it will tell me the real reason such as the destination drive being out of space. I put a try catch around my command but it gives the same error I see from the job. How do I capture the error that SSMS is providing?

  • Are you looking at the Job Step's details for the error when it fails?...that's usually more detailed than the Job's details, in the History window. – J.D. Mar 24 at 14:25
  • Yes. Although more verbose than what I've written, since it gives the percentage it got through, It still amounts to the same error. Backup log is terminating abnormally. The statement has been terminated. The step failed. – Lumpy Mar 24 at 15:45
  • Can you include a screenshot of the job history showing this? It should show both errors (the inner and outer) in the job history. – HandyD Mar 25 at 3:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.