Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

share|improve this question

migrated from stackoverflow.com Jun 14 '10 at 0:47

This question came from our site for professional and enthusiast programmers.

    
Did they give you a database BAK file, or an NT backup file? –  Remus Rusanu Jun 13 '10 at 17:07
    
yes, but it is created as a SQL Server backup, or an NT backup? –  Remus Rusanu Jun 13 '10 at 17:28
    
Asked later too: stackoverflow.com/questions/3033265 –  gbn Jun 13 '10 at 18:49
add comment

1 Answer

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.

share|improve this answer
    
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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.