Exit Code 110

SloopJohnB

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.

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.

SloopJohnB

HJoyce, thanks. That was indeed the problem.

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