Decrease Font Size
Increase Font Size
   BLOG

SQL Server cannot process this media family

by bryian 29. May 2010 18:16

Problem:

You are getting the error message shown below while trying to restore a database.

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
ADDITIONAL INFORMATION:
The media family on device 'C:\ysatech\db\MyDB.bak' is incorrectly formed.

SQL Server cannot process this media family.
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)
For help, click: here


Solution:

Make sure that you are not restoring the backup from SQL 2008 to SQL 2005 instance.

Comments

5/12/2010 4:24:27 PM #

Kate

I also had the same error 3241 with SQL, but after stopping the restore it disappeared, thanks.

Kate United States

5/12/2010 5:40:08 PM #

Hip Hop Songs

I don't typically leave a comment, but I like the information that is given.

Hip Hop Songs United States

5/16/2010 9:19:35 AM #

Free Hosting

Really its article very informative and interesting and i think it should be helpful for all the coders..

Free Hosting United States

5/22/2010 2:08:45 PM #

SuziW

Great information - thanks!

SuziW Australia

6/21/2010 11:59:47 AM #

dotnetguts

I was having some what similar issue and I solved it.  I was trying restore with SQL Server 2008 DB.

I have documented each step, which help me to resolve this problem.

Please read this blog: dotnetguts.blogspot.com/.../...server-restore.html

dotnetguts United States

10/12/2010 3:15:11 AM #

Clarak Anderson

Thanks for your tips. I will follow your tips, if I need.

Clarak Anderson United States

10/21/2010 5:33:33 PM #

Mike J

I am getting this error as well. Confirmed both versions, and they are 10.0.1600, but noticed the remote server is x64. So you cannot restore a DB from an X64 server onto an x86 server, even if both are sql2008?
(apologies if double-post, corrected my email address)

Mike J South Africa

11/16/2010 6:07:34 PM #

Greg Pinouse

I'm still getting the message even though im not restoring the backup from 2008. What else can i do?

Greg Pinouse Greece

1/3/2011 8:49:25 PM #

ugg outlet

I also had the same error 3241 with SQL, but after stopping the restore it disappeared, thanks.

ugg outlet People's Republic of China