Unable to restore

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?

Microsoft SQL ServerStorage SoftwareMicrosoft Legacy OS

Last Comment

VENKAT KOKULLA

8/22/2022 - Mon

sachitjain

12/27/2012

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.

Peter Chan

12/27/2012

ASKER

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

ASKER CERTIFIED SOLUTION

igordevelop

12/28/2012

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

SOLUTION