Error 3241: The media family on device is incorrectly formed

Sometimes we may receive the below error message when restoring the database from the backup file using SQL Server Management Studio:

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

RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)


Error 3241 - The Media Family on Device is Incorrectly Formed


Cause:

The backup file was corrupted due to file uploaded using FTP Text Mode.

Solution:

Need to always upload the backup file using FTP in Binary Mode and then restore operation will be successful.
  • 3 Users Found This Useful

Was this answer helpful?

Related Articles

Fix - Session Timeout after some seconds in umbraco installation

Problem statement Umbraco installation is throwing 401 error while uploading images....

Can I Send Emails without SMTP authentication?

Linux Shared Hosting  With Linux Shared Hosting, we allow sending emails without SMTP...

500 Internal Server Error

In Windows hosting, sometimes you may get error message 500 Internal Server Error for scripts...

Operation must use an updateable query Microsoft OLE DB Provider for ODBC Drivers error '80004005' .[Microsoft] [ODBC Microsoft Access Driver]

This error usually occurs when you try to insert or update data in MS Access database i.e. you do...

How to emulate register_globals in PHP 5.4

During our recent Linux server migration task, we faced following strange issue: Some websites...