Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Got sql error 3241

Posted on 2011-03-07
4
Medium Priority
?
1,274 Views
Last Modified: 2016-03-23
Hi, I'm using sql 2005 express. I want to restore a database using bak file from another server to my local PC so I can have a copy of that database here.  However, I got the following error.  How can I fix this?  Thanks.
TITLE: Microsoft SQL Server Management Studio
------------------------------

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

------------------------------
ADDITIONAL INFORMATION:

The media family on device 'C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\meddb.bak' is incorrectly formed. SQL Server cannot process this media family.
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=3241&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------
0
Comment
Question by:lapucca
3 Comments
 
LVL 12

Accepted Solution

by:
Gary Dewrell earned 1600 total points
ID: 35062020
0
 
LVL 9

Assisted Solution

by:kaminda
kaminda earned 400 total points
ID: 35065697
What is the version of the SQL Server of the bak file. If it is 2008 it is probably the case. Other possibility is a corrupt backup file. But I would guess first one is the scenario here.
0
 

Author Closing Comment

by:lapucca
ID: 35071675
The bak file is from 2008.  thank you.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

782 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question