Restore failed with Exit Code 280?

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

Restore failed with Exit Code 280?

Postby swelsh » Tue Jan 24, 2012 6: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.
swelsh
 
Posts: 9
Joined: Fri Jan 13, 2012 1:10 am
Location: Palm Harbor, FL

Postby eddie davis » Wed Jan 25, 2012 8: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 support@red-gate.com 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
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software


Return to SQL Backup 6

Who is online

Users browsing this forum: No registered users and 0 guests