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

SQL backup failing (again) :)

Hello again, we have another job for backing up the transaction logs which is occasionally failing:
SQL Backup failed with exit code: 1010 SQL error code: 4208 [SQLSTATE 42000] (Error 50000). The step failed.

I can't find what this exist code means, have searched the forums and internet. If any one knows what it means can you also point me to any documentation which will explain exit code meanings so I don't have to keep pestering people on these forums :)

Thanks.
Datacentre
0

Comments

2 comments

Sort by
  • Datacentre
    Have found the error code documentation:

    http://documentation.red-gate.com/displ ... 500+-+5292
    Datacentre
    0
  • petey
    SQL Backup generates a log file for each process that it runs. The default folder where the logs are stored is C:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Log\<instance name> on Windows 2003 and older, and C:\ProgramData\Red Gate\SQL Backup\Log\<instance name> on Windows Vista and newer.

    Could you please post the contents of the log file for the failed backup?
    petey
    0

Add comment

Please sign in to leave a comment.