[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1297
  • Last Modified:

Got sql error 3241

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
lapucca
Asked:
lapucca
2 Solutions
 
Gary DewrellSenior Network AdministratorCommented:
0
 
kamindaCommented:
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
 
lapuccaAuthor Commented:
The bak file is from 2008.  thank you.
0

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now