Problem:
You are getting the error message shown below while trying to restore a database.
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
ADDITIONAL INFORMATION:
The media family on device 'C:\ysatech\db\MyDB.bak' is incorrectly formed.
SQL Server cannot process this media family.
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)
For help, click: here
Solution:
Make sure that you are not restoring the backup from SQL 2008 to SQL 2005 instance.