What are the challenges you face when working across database platforms? Take the survey
Options

Utility to go to native backup

dbenoitdbenoit Posts: 10
edited September 24, 2008 10:19PM in SQL Backup Previous Versions
Greetings,

We are having an issue with restoring a database using version 5.3 and getting the following error;

Thread 0 error:
EOF#2 validation failed. Device 1. Expected 274726, available 67596.

Thread 1 error:
EOF#2 validation failed. Device 1. Expected 274726, available 67596.

Thread 2 error:
EOF#2 validation failed. Device 1. Expected 274726, available 67596.

SQL error 3013: SQL error 3013: RESTORE DATABASE is terminating abnormally.
SQL error 3203: SQL error 3203: Read on "SQLBACKUP_EB07206A-02FD-435F-A6C0-7A4739C91EBA02" failed: 995(The I/O operation has been aborted because of either a thread exit or an application request.)

SQL Backup exit code: 790
SQL error code: 3203


Wondering if there is a way that we can either get the meaning of this error or better yet, convert this backup to native format so that we can do a native restore and work through the errors that way. Any information you can provide would be greatly appreciated.

Thanks.

David
David

Comments

  • Options
    peteypetey Posts: 2,358 New member
    The backup file appears to be incomplete. Could you please send us the SQL Backup log file for that restore? By default, the log files are stored in C:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Log\<instance name>.

    Thanks.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.