Solved

Unable to restore

Posted on 2012-12-27
5
449 Views
Last Modified: 2012-12-28
Hi,
I am getting this error when restoring the backup file
USE [master]

RESTORE HEADERONLY FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SS08R2WIN12\MSSQL\Restore\my_schema.bak';
RESTORE FILELISTONLY FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SS08R2WIN12\MSSQL\Restore\my_schema.bak';

RESTORE DATABASE [my_schema]
FROM  DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SS08R2WIN12\MSSQL\Restore\my_schema.bak'
WITH  FILE = 1;
GO


(1 row(s) affected)
Msg 3241, Level 16, State 13, Line 4
The media family on device 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SS08R2WIN12\MSSQL\Restore\my_schema.bak' is incorrectly formed. SQL Server cannot process this media family.
Msg 3013, Level 16, State 1, Line 4
RESTORE FILELIST is terminating abnormally.
Msg 3241, Level 16, State 13, Line 6
The media family on device 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SS08R2WIN12\MSSQL\Restore\my_schema.bak' is incorrectly formed. SQL Server cannot process this media family.
Msg 3013, Level 16, State 1, Line 6
RESTORE DATABASE is terminating abnormally.

If the backup is from Sql server 2012, how can I restore the backup file into Sql server 2008 DB?
0
Comment
Question by:HuaMinChen
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 12

Expert Comment

by:sachitjain
ID: 38725941
Sorry to say but SQL Server does not allow backups taken on higher versions to be restored on lower versions but its possible the other way

http://www.mytechmantra.com/LearnSQLServer/Unable_to_Restore_Database_From_Backup.html

You may need to find some alternative way to do this.
0
 
LVL 11

Author Comment

by:HuaMinChen
ID: 38725982
I try to attach both mdf and ldf files to Sql server 2008 but I've got this. Is there a way to resolve this?
TITLE: Microsoft SQL Server Management Studio
------------------------------

Attach database failed for Server 'win2012dc\SS08R2WIN12'.  (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1+((KJ_RTM).100402-1539+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476

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

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

------------------------------

The database 'my_schema' cannot be opened because it is version 706. This server supports version 661 and earlier. A downgrade path is not supported.
Could not open new database 'my_schema'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948)

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

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

OK
------------------------------

Many Thanks & Best Regards, Hua Min
0
 
LVL 1

Accepted Solution

by:
igordevelop earned 250 total points
ID: 38726510
Hi,

No, you can not do anything with .mdf, .bak, or any other SQL 2012 file on SQL 2008.
It's just not possible to go in that direction. If it was reverse, there would be no problem.

Let me know if anything.

Regards,
Igor Janevski
0
 
LVL 57

Assisted Solution

by:Raja Jegan R
Raja Jegan R earned 250 total points
ID: 38726610
Hua Min,

As mentioned above, you cannot restore a database backup taken from SQL Server 2008 R2 onto SQL Server 2008. Instead you can go with workarounds given below:

1. Use Generate Scripts wizard on SQL Server 2008 R2 database to script data also in addition to the structures.
More info about Generate Scripts wizard and Script data option below:
http://blog.sqlauthority.com/2009/07/29/sql-server-2008-copy-database-with-data-generate-t-sql-for-inserting-data-from-one-table-to-another-table/
2. Once scripts are generated, you can run these scripts in SQL Server 2008 machine to create the database.
0
 
LVL 5

Expert Comment

by:VENKAT KOKULLA
ID: 38726633
Instead of trying to restore the backup of sql 2012, try to export the complete data will work out?
I'm not sure.. please try in that way..
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Viewers will learn how the fundamental information of how to create a table.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

726 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