Error 3241 when trying to restore or attach a database.


Receive an error when trying to attach or restore a MS_SLQ database "The media family on device <DEVICE NAME> is incorrectly formed. SQL Server cannot process this media family.
RESTORE HEADERONLY is terminating abnormally. MicroSoft SQL Server, Error: 3241"


This error will occur when attempting to mount a new database version to an older MS-SQL Server installation. For example, this will occur when trying to attach/restore a database from MS-SQL Server 2008 R2 to MS-SQL Server 2008 Express (not R2).


Upgrade the database to a least the same version as was used to create the database.
How did we do with this article?