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

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

1 Answer 1

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

 
discard

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.