Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have created a backup of my production database and whenever I try to restore it on my local machine I get the following error:

The media family on device C:\projects.......name_of_the_database_.bak is incorrectly formed. SQL SERVER cannot process this media family. RESTORE HEADERONLY is terminating abnormally.

share|improve this question
How are you transferring the backup file to your machine? – joeqwerty Jul 7 '10 at 19:27
up vote 1 down vote accepted

I have seen this when trying to restore from portable media. Try copying the file to your machine first then restoring.

share|improve this answer
I used the export data option as the restore was not working correctly. – user21004 Jul 7 '10 at 21:06

Your Answer


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

Not the answer you're looking for? Browse other questions tagged or ask your own question.