How can we help you today? How can we help you today?

Exit Code 110

I have a daily backup job which emails me a report. I receive the email saying "SUCCESS:...", but the SQL Server job history has the job marked as failed with the folllowing error text: "SQL Backup job failed with exitcode: 110 SQL error code: 0 [SQLSTATE 42000] (Error 50000). The step failed."

I checked the folder with the backups and they seem to be in place. Why am I getting this error? :?

TIA for any/all help.
SloopJohnB
0

Comments

2 comments

Sort by
  • HJoyce
    Error 110 is "Failed to save primary log file"
    To let you know, there is a list of error codes in the troubleshooting section of the help file.

    In SQL Backup if you open the Options dialog and go to the Log Files tab you will see the default location for the SQL Backup log files. There must be some problem (probably permissions) with writing to this location. The backup will still succeed as you have found.
    HJoyce
    0
  • SloopJohnB
    HJoyce, thanks. That was indeed the problem.

    I guess I should have checked help more closely. :oops: Sorry about that.
    SloopJohnB
    0

Add comment

Please sign in to leave a comment.