Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.
COURSE of the MONTH
9 days, 5 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Unable to restore
Posted on 2012-12-27
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
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?
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?
[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
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.
http://www.mytechmantra.com/LearnSQLServer/Unable_to_Restore_Database_From_Backup.html
You may need to find some alternative way to do this.
Active today
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
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
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
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.
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.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL).
Depending on business requirements, a single Stored Procedure can return differe…
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses
Course of the Month9 days, 5 hours left to enroll
764 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.