Issue: When restoring a database in SQL Server Management Studio, the following error occurs in the form:
The media family on device....is incorrectly formed. SQL Server cannot process this media family (as shown below).
Resolution: This error can occur when you attempt to restore a database backup that was taken with SQL Server 2008 onto a server running SQL Server 2005. If the backup is from 2008, you will need to use SQL Server 2008 Express to restore it - backups (and databases) are not backwards compatible with older versions.
Note: Run the query below in SQL to determine your server version