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

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

Error 1503: Error while restarting MySQL service on Windows server

You may need to restart MySQL services from Services on Windows server. While restarting service,...

How to emulate register_globals in PHP 5.4

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