Competition: What’s your favorite Redgate tool? Enter now.

Exit Code 110

SloopJohnBSloopJohnB Posts: 25 Bronze 3
edited August 1, 2006 12:49PM in SQL Backup Previous Versions
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.

Comments

  • 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.
    Helen Joyce
    SQL Backup Project Manager
    Red Gate Software
  • SloopJohnBSloopJohnB Posts: 25 Bronze 3
    HJoyce, thanks. That was indeed the problem.

    I guess I should have checked help more closely. :oops: Sorry about that.
Sign In or Register to comment.