Restoring a SQL 2012 database in a SQL 2014 database

Hello,

I made a backup of a database from SQL Server 2012 and tried to restore this .bak file in a SQL Server 2014 database. I got the next error message while doing this:

The media family on device 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\MyDatabase.bak' is incorrectly formed. SQL Server cannot process this media family.

Does anyone know how to solve this?

Regards,

Arne
adiemeerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mark GalvinManaging Director / Principal ConsultantCommented:
Hi

This article seems pretty much what youre looking for :
http://saurabhsinhainblogs.blogspot.in/2013/05/the-media-family-on-device-daeppbak-is.html

Thanks
Mark
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Vikas GargBusiness Intelligence DeveloperCommented:
Hello,

Have you taken backup using third party toll like lite speed red gate ?

If it is the case then you can not restore the same.

Please make sure that you are restoring to the right version if you have multiple instance at the destination.
0
adiemeerAuthor Commented:
@Mark: I read your article. The answer to my error message in this article is: Backup is correct and one is trying to restore on lower version or backup was done using some third party tool like lite speed ,red gate etc

As I tried to restore a 2012 backup to a 2014 version, the first reason is not applicable. I'm not restoring to a lower version, but to a higher version. The second reason, backup using a third party tool is also not applicable as far as I know. I used SQL Server Management Studio to make the backup manualy (by right clicking on the database, then Tasks/Backup).
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Mark GalvinManaging Director / Principal ConsultantCommented:
Are you able to restore the .bak to the server you backed it up from? Just to rule out corruption?
0
Mark GalvinManaging Director / Principal ConsultantCommented:
Also, how did you transfer the .bak file between servers?
0
adiemeerAuthor Commented:
@Mark: I created a mapping between the server I backed up from and the server where I want to do the restore. Transfer was to copy from the backup folder at the source server to a filefolder at the destination server. I tried to restore by selecting the backup in the filefolder.

I will try to restore at the server I backed up from and will let you know.
0
adiemeerAuthor Commented:
@Mark: I checked the backup both at the source server and the destination server by using the RESTORE VERIFYONLY command. At the source server I get the message the backup set on file 1 is valid. At the destination server the error message. So the backup is OK. It must be either the transfer between the source and destination server or the SQL Server version that is heigher at the destination server.
0
Mark GalvinManaging Director / Principal ConsultantCommented:
Very strange. Having a higher version at the destination shouln't make a difference.

Im at a loss here.

Sorry
Mark
0
adiemeerAuthor Commented:
@Mark: I now see what went wrong. I am using Microsoft SQL Server 2014 Management Studio. Within this Management Studio I have several Database Engines. I now checked the version number of the Database Engine I used for restoring with the command SELECT @@VERSION. And it seems that this is version 2008. I wasn't realizing that this version could be different as the Management Studio version. So actually I was misinforming you, apologies. Your first answer actually is the answer to the problem :-)
0
adiemeerAuthor Commented:
Thanks for your time
0
Mark GalvinManaging Director / Principal ConsultantCommented:
Glad I could help!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.