The media family on device....is incorrectly formed. SQL Server cannot process this media family

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

error_for_KB.png

 

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

SELECT@@VERSION

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk