up vote 1 down vote favorite
share [g+] share [fb]

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.

link|improve this question
14% accept rate
How are you transferring the backup file to your machine? – joeqwerty Jul 7 '10 at 19:27
feedback

1 Answer

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.

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

Your Answer

 
or
required, but never shown
discard

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