Error 570: File is not a SQL Backup file.

fais

Hi,

I have a job to restore 10 production database on Test server.

Right now the problem that I am facing is : Sometimes 7 are successful restore and 3 fails with the following error : Error 570: File is not a SQL Backup file. and database goes into recovering state and then stays there. ( non funtional )

Then I have to manually delete the databases and then clean the files and then start the restore again. with my second attmept, all are restored successfully with same backup files .

Can anyone help to alleviate this issue.

I am using SQL Backup version : 6.2.0.134


Thanks

ChrisAVWood

As you are using 6.2 what does the Red gate log show? From the GUI right click on Show Log on the failed job.

Chris

fais

On the failed restored, Red gate log says :

SQL Backup log file 6.2.0.134.

Sometimes , it also records below errors : (But later on , when I use same backup file., it works good ).

12/14/2009 6:22:02 PM: Thread 0 error:
EOF#2 validation failed. Device 0. Expected 276813, available 57210. Error 0 (The operation completed successfully.).
12/14/2009 6:22:02 PM:
12/14/2009 6:22:02 PM: Thread 1 error:
EOF#2 validation failed. Device 0. Expected 276813, available 57210. Error 0 (The operation completed successfully.).
12/14/2009 6:22:02 PM:
12/14/2009 6:22:03 PM: SQL error 3013: SQL error 3013: RESTORE DATABASE is terminating abnormally.
12/14/2009 6:22:03 PM: SQL error 3241: SQL error 3241: The media family on device 'SQLBACKUP_ED2286B0-3DE6-4A67-B000-E2069B5FAA5C' is incorrectly formed. SQL Server cannot process this media family.

jerryhung

Were these 3 files copied successfully for sure?

I'd use SQBConverter.exe to convert them back to .BAK file to make sure

Otherwise to be safe, re-copy those files


We had something like this last week where FTP didn't copy the .sqb files successfully

fais

Can anyone from Red-gate support look into this issue . Its very important for our businees that we dont have these errors.

Thanks

ChrisAVWood

This might be a thread error. We do something similar copying backup files to another server to restore them to run DBCC CHECKDB on the restored database.

We got the occasional thread error and had to restrict how many backups we try to restore at any one time.

You might want to adjust the MAXTRANSFERSIZE parameter.

HTH

Chris