Media Family Incorrectly Formed- Sql Server Restore Error

When I was trying to restore sql server database from a client’s backup file, I had following error message:

The media family on device ‘C:\Temp\databasebackup.bak’ is incorrectly formed. SQL Server cannot process this media family.

Search on the internet came back with a lot of suggestions, so I also tried to verify the file with : restore verifyonly from disk=’C:\Temp\databasebackup.bak’

And it gave me the same error message.

To my surprise none of the searches I have come by had covered my case, it is simple, just so let you know that in my case the backup was made from SQL Server 2008, while I was trying to restore it to SQL Server 2005 and SQL Server 2000.

So try it on a 2008 server first to see if the problem persists.

This entry was posted on Tuesday, September 7th, 2010 at 2:31 am and is filed under SQLServer. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply