I have downloaded databasename.bak file from my hosting company, when i tried to restore that DB file in SQL server 2008 it is keep on giving me following error.

The media family on device 'C:\go4sharepoint_1384_8481.bak' is incorrectly formed. SQL Server cannot process this media family. RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)

According to this error and from following link http://www.sqlcoffee.com/Troubleshooting047.htm

It is clear that either file i am downloading is corrupt or it is getting corrupted on the way?

Any idea, why I am keep on receiving this error? I tried almost all ways but unable to fix this problem, please help me.


If you can, try to restore the backup in the same server/PC where that database backup was originally created. If it fails, it's clear that is not a communication issue (file corrupted because the FTP transfer) and something went wrong in the backup process.

If this works, you know the backup is not corrupted and the files becomes corrupt in the file transfer.

  • Thanks Markust for pointing light, let me try this and update you on this. – Jordon Jun 13 '10 at 17:25
  • I just tried doing that It was running good on server. So the problem is file gets corrupted because of FTP Transfer. For file transfer I am using FTP - FileZila with TransferType as Binary, still it is giving problem, any idea? – Jordon Jun 13 '10 at 17:34
  • 1
    I always I try to zip (using 7zip, Winzip or WinRar) the files whenever possible. Try to zip it and then do the transfer. Once you have the file, if you are unable to unzip it is because its corrupted again. At least this way you know in advance whether the file is valid or not. In FileZilla I use autodetect and works for me – Markust Jun 13 '10 at 17:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy