Restore failed with Exit Code 280?

Forum for users of Redgate's SQL Backup tool

Restore failed with Exit Code 280?

Postby swelsh » Tue Jan 24, 2012 5:23 pm

We have a job that nightly restores a copy of a production database to a reporting environment and had an issue last night where the backup ran long and caused the restore job to retry a few times before succeeding as the backup file was still being written to. However the last retry before the successful run exhibited an odd behavior and ran longer than all the other retries. This is the error message:

Code: Select all
RESTORE DATABASE successfully processed 57347713 pages in 5679.849 seconds (82.712 MB/sec).
SQL Backup exit code: 280

(38 rows(s) affected)

name                                                             value                                                                                                                                                                                                                                                               
exitcode                                                         280
sqlerrorcode                                                     0
filename001                                                      [-- file name removed --]

(3 rows(s) affected)

Msg 50000, Sev 18, State 1, Line 35 : Red-Gate SQL Restore failed [SQLSTATE 42000]

And I cannot find any documentation on what Exit Code 280 signifies.
Posts: 9
Joined: Fri Jan 13, 2012 12:10 am
Location: Palm Harbor, FL

Postby eddie davis » Wed Jan 25, 2012 7:51 pm

Thank you for your post into the forum and sorry that you have encountered a problem.

I must admit, exit code 280 is new warning code that I have not seen before. In SQL Backup Exit Codes 499 and below are warning codes and 500 and above are error codes.

A support call has been created for you, the call reference number is F0056667. Can you please send an e-mail to and include the call reference F0056667 in the subject field of the e-mail. Please attach a copy of the SQL Backup log file for this restore and confirm the exact version of SQL Backup you are using.

Many Thanks
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
eddie davis
Posts: 1146
Joined: Wed Jun 14, 2006 2:47 pm
Location: Red Gate Software

Return to SQL Backup Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests