Saturday, June 16, 2012

Error: 3241, The Media Family on Device is Incorrectly Formed.

Today I was trying to restore a database backup using SSMS. The backup was sent by my friend through FTP. But SSMS raised the following error:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

The media family on device 'C:\Temp\DB_Customer.bak' is incorrectly formed. SQL Server cannot process this media family.
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241) 

The main cause of the problem was backup was corrupted. The file was transferred using FTP in text mode rather than binary mode.

The backup file was transferred again using FTP in binary mode. Then the restore operation was successful.

1 comment:

  1. Now users can easily fix SQL backup error 3241 & smoothly restore SQL backup file by using SQL backup recovery tool.