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.