{"id":58,"date":"2011-07-13T07:55:43","date_gmt":"2011-07-13T07:55:43","guid":{"rendered":"https:\/\/sqlserverlearner.azurewebsites.net\/2011\/07\/13\/the-media-family-on-device-is-incorrectly-formed-sql-server-cannot-process-this-media-family-error-3241\/"},"modified":"2011-07-13T07:55:43","modified_gmt":"2011-07-13T07:55:43","slug":"the-media-family-on-device-is-incorrectly-formed-sql-server-cannot-process-this-media-family-error-3241","status":"publish","type":"post","link":"https:\/\/sqlserverlearner.com\/2011\/07\/13\/the-media-family-on-device-is-incorrectly-formed-sql-server-cannot-process-this-media-family-error-3241\/","title":{"rendered":"The media family on device is incorrectly formed. SQL Server cannot process this media family Error: 3241"},"content":{"rendered":"<p>When you try to restore a backup of the database you get the following error:<\/p>\n<p><font color=\"red\"><br \/>\nThe media family on device &#8221; is incorrectly formed. SQL Server cannot process this media family.<br \/>\nRESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)<br \/>\n<\/font><\/p>\n<p>This error occurs due to the following problems:<\/p>\n<ul>\n<li><strong>Backup file is corrupted.<\/strong><br \/>\n<br \/>\n<em>The following post helps you verify your database backup: <a href=\"http:\/\/sqlserverlearner.com\/2012\/verify-sql-server-database-backup\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Verify SQL Server Database Backup<\/strong><\/a><\/li>\n<p><\/em><\/p>\n<li> <strong>Backup was taken on a higher version of SQL Server and restoration is being done on the earlier version.<\/strong><br \/>\n<br \/>\n<em>The following post gives you more details about this: <a href=\"http:\/\/sqlserverlearner.com\/2011\/restore-higher-version-database-backup-on-lower-version-sql-server-restore-problem\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>restore higher version database backup on lower version sql server \u2013 restore problem<\/strong><\/a><\/li>\n<p><\/em>\n<\/li>\n<\/ul>\n<p>Fix:<\/p>\n<ul>\n<li>If you feel backup could be corrupted take the backup again<\/li>\n<li>If you are using FTP then use it in binary mode to copy the backup file into local drive<\/li>\n<li>If the versions are different then update the SQL Server on the system into which the backup has to be restored<\/li>\n<li>Verify the database backup to check what the issue is.<br \/>\nFollowing post helps you verify your database backup: <a href=\"http:\/\/sqlserverlearner.com\/2012\/verify-sql-server-database-backup\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Verify SQL Server Database Backup<\/strong><\/a><\/li>\n<p>More about using <strong>restore verify only this <\/strong>option in SQL Server can be found <strong><a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ms188902.aspx\" target=\"_blank\" rel=\"noopener noreferrer\">here<\/a><\/strong>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>When you try to restore a backup of the database you get the following error: The media family on device &#8221; is incorrectly formed. SQL Server cannot process this media family. RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241) This error occurs due to the following problems: Backup file is corrupted. The following&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[137,128,3],"tags":[138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159],"class_list":["post-58","post","type-post","status-publish","format-standard","hentry","category-databasebackup","category-sql-errors","category-sqlserverpedia-syndication","tag-error-3241","tag-help-the-media-family-on-device-is-incorrectly-formed","tag-how-to-fix-the-media-family-on-device-is-incorrectly-formed-error","tag-media-family-on-device-is-incorrectly-formed-sql-2005","tag-media-family-on-device-is-incorrectly-formed-sql-2008","tag-media-family-on-device-is-incorrectly-formed-sql-server-2000","tag-media-family-on-device-is-incorrectly-formed-sql-server-2005","tag-media-family-on-device-is-incorrectly-formed-sql-server-2008","tag-media-file-on-device-is-incorrectly-formed","tag-microsoft-sql-server-error-3241","tag-restore-headeronly-is-terminating-abnormally-microsoft-sql-server-error-3241","tag-sql-server-error-the-media-family-on-device-is-incorrectly-formed","tag-the-media-family-on-device","tag-the-media-family-on-device-is","tag-the-media-family-on-device-is-incorrectly-formed","tag-the-media-family-on-device-is-incorrectly-formed-3241","tag-the-media-family-on-device-is-incorrectly-formed-restore-headeronly","tag-the-media-family-on-device-is-incorrectly-formed-sql-server-cannot-process-this-media-family-restore-headeronly","tag-the-media-family-on-device-is-incorrectly-formed-sql-server-cannot-process-this-media-family","tag-the-media-family-on-device-is-incorrectly-formed-sql-server-cannot-process-this-media-family-restore-headeronly-is-terminating-abnormally-microsoft-sql-server-error-3241","tag-the-media-family-on-device-is-incorrectly-formed-sqlserver-cannot-process-this-media-family-issue-fixed","tag-why-am-i-getting-the-media-family-on-device-is-incorrectly-formed-error"],"_links":{"self":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/58","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/comments?post=58"}],"version-history":[{"count":0,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/58\/revisions"}],"wp:attachment":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/media?parent=58"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/categories?post=58"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/tags?post=58"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}