SQL backup failing (again) :)

Datacentre · July 30, 2014 6:21AM

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 · July 30, 2014 12:03PM

Have found the error code documentation:

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

petey · August 1, 2014 12:10AM

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?

SQL backup failing (again) :)

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk