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 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

migrated from stackoverflow.com Jul 8 '10 at 0:39

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

    
Is the production server the same SQL Server version, 2005 ?? –  marc_s Jul 7 '10 at 21:20

2 Answers 2

I think the problem is that you named the media when doing the backup, and by default Enterprise Manager requires that the names match. In the restore GUI go to the second tab, and uncheck the box that says match media name (or something to that effect). Or do the restore in Query Analyser. That should do it for you =)

share|improve this answer

Check the following:

  1. Make sure your local machine is using SQL Server 2005 (not Express) or a later edition. You cannot restore a 2005 database on a 2000 server.

  2. Check that the backup fully copied over to your machine. Restoring a corrupted backup has prompted me with that message before.

share|improve this answer

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.