Peter Chan
asked on
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.SS08R2WI N12\MSSQL\ Restore\my _schema.ba k';
RESTORE FILELISTONLY FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SS08R2WI N12\MSSQL\ Restore\my _schema.ba k';
RESTORE DATABASE [my_schema]
FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SS08R2WI N12\MSSQL\ Restore\my _schema.ba k'
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.SS08R2WI N12\MSSQL\ Restore\my _schema.ba k' 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.SS08R2WI N12\MSSQL\ Restore\my _schema.ba k' 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?
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.SS08R2WI
RESTORE FILELISTONLY FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SS08R2WI
RESTORE DATABASE [my_schema]
FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SS08R2WI
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.SS08R2WI
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.SS08R2WI
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?
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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..
I'm not sure.. please try in that way..
http://www.mytechmantra.com/LearnSQLServer/Unable_to_Restore_Database_From_Backup.html
You may need to find some alternative way to do this.