SQL backup failing (again) :)

Datacentre

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

Have found the error code documentation:

http://documentation.red-gate.com/displ ... 500+-+5292

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?