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 1503: Error while restarting MySQL service on Windows server

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

500 Internal Server Error

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

How to Fix Runtime Error on Website with SDF Database?

Problem Statement Runtime error on website having Database on SDF file. Solution Start IIS...

While running my ASP.NET Application, I am receiving full trust level error

Exception Details System.Security.SecurityException: Request for the permission of type...