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

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

Fix - Session Timeout after some seconds in umbraco installation

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

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

Server Error in '/' Application in WebsitePanel :: Windows Server 2003 VPS

You may receive the following errors when running WebsitePanel installed on Windows 2003 server:...