SQL backup, restore problem

Question

0.00/5 (No votes)

See more:

I have a SQL backup file and I can't restore it.
the file is not corrupted because I couldt restore it on another PC with same version of SQL as mine. and My SQL server is OK because I could Back up a database and restore it on my SQL server.
When I add the file I catch this message:

The media family on device 'D:\Hatamzadeh\DataBase\bak900628\900628.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.5057&EvtSrc=MSSQLServer&EvtID=3241&LinkId=20476

PLEASE HELP ME.

Posted 4-Oct-11 0:30am

m_taha_h

Updated 4-Oct-11 0:43am

Pravin Patil, Mumbai

v2

Add a Solution

2 solutions

Solution 2

thanks for your answer.
I know this. And I can restore this bak file on another PC with the version as my SQL version. so the SQL version is OK.

Posted 4-Oct-11 0:54am

m_taha_h

Comments

André Kraak 4-Oct-11 6:54am

If you have a question about or comment on the given solution use the "Have a Question or Comment?" option beneath the solution. When using this option the person who gave the solution gets an e-mail message and knows you placed a comment and can respond if he/she wants.

Please move the content of this solution to the solution you are commenting on and remove the solution. Thank you.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mehdi Gholam · Accepted Answer · 2011-10-04T00:43:00

Solution 1

You can restore backup to a same version or greater SQL Server, not to a lower one.

Posted 4-Oct-11 0:43am

Mehdi Gholam

Comments

Pravin Patil, Mumbai 4-Oct-11 6:44am

My 5....