SQL SERVER Restore Problems

Question

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.

How are you transferring the backup file to your machine? – joeqwerty Jul 07 '10 at 19:27 — joeqwerty, Jul 07 '10 at 19:27

score 1 · Accepted Answer · answered Jul 07 '10 at 19:43

1

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

answered Jul 07 '10 at 19:43

Jim B

24,141

I used the export data option as the restore was not working correctly. – user21004 Jul 07 '10 at 21:06

SQL SERVER Restore Problems

1 Answers1