Options

Error 570: File is not a SQL Backup file.

faisfais Posts: 21
edited December 15, 2009 11:54AM in SQL Backup Previous Versions
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
· Share on Twitter

Comments

  • Options
    ChrisAVWoodChrisAVWood Posts: 361
    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
    English DBA living in CANADA
    · Share on Twitter
  • Options
    faisfais Posts: 21
    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.
    · Share on Twitter
  • Options
    jerryhungjerryhung Posts: 138
    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
    Jerry Hung
    DBA, MCITP
    · Share on Twitter
  • Options
    faisfais Posts: 21
    Can anyone from Red-gate support look into this issue . Its very important for our businees that we dont have these errors.

    Thanks
    · Share on Twitter
  • Options
    ChrisAVWoodChrisAVWood Posts: 361
    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
    English DBA living in CANADA
    · Share on Twitter
Sign In or Register to comment.