When you try to restore a backup of the database you get the following error:
The media family on device ” is incorrectly formed. SQL Server cannot process this media family.
RESTORE HEADER ONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)
This error occurs due to the following problems:
1. Backup file is corrupted.
2. Backup was taken on a higher version of SQL Server and restoration is being done on the earlier version.
Fix :
1. If you feel backup could be corrupted take the backup again
2. If you are using FTP then use it in binary mode to copy the backup file into local drive
3. If the versions are different then update the SQL Server on the system into which the backup has to be restored
4. Verify the database backup to check what the issue is.
The media family on device ” is incorrectly formed. SQL Server cannot process this media family.
RESTORE HEADER ONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)
This error occurs due to the following problems:
1. Backup file is corrupted.
2. Backup was taken on a higher version of SQL Server and restoration is being done on the earlier version.
Fix :
1. If you feel backup could be corrupted take the backup again
2. If you are using FTP then use it in binary mode to copy the backup file into local drive
3. If the versions are different then update the SQL Server on the system into which the backup has to be restored
4. Verify the database backup to check what the issue is.
This comment has been removed by the author.
ReplyDeleteIf your SQL backup has got corrupted due to any reasons then you can use SQL backup recovery tool to repair corrupt SQL BAK file & successfully restore SQL backup database. Read more about this tool http://www.sqlrecoverysoftware.net/blog/sql-error-3241.html
ReplyDelete