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

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

Error 80004005 The Microsoft Jet Database Engine Cannot Open the File

Following are the possible causes of this error: This error usually occurs when database file or...

Can I Send Emails without SMTP authentication?

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

Fix - Session Timeout after some seconds in umbraco installation

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

Various Outlook/Outlook Express Error Codes

Error Code Description 0x800CCCF4 HTTPMail Your outlook settings may...