Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

I cannot restore a SQL 2012 .bak file to SQL 2005, correct?

Posted on 2014-11-18
4
Medium Priority
?
230 Views
Last Modified: 2014-11-18
Hi! I just need to confirm I am correct when I am concluding that a .bak file created from a SQL 2012 database cannot be restored into a SQL 2005 environment, correct?
0
Comment
Question by:mrosier
  • 2
  • 2
4 Comments
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 2000 total points
ID: 40450028
That's right,  you cannot restore the back ups from a higher version on to a lower version
0
 

Author Comment

by:mrosier
ID: 40450038
Is it possible to create a .bak file in SQL 2012 that would restore into 2005 using some kind of compatability option during creation?
0
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 40450065
No its not possible, if you just want to export the data, you can use the inport export data wizard.
0
 

Author Comment

by:mrosier
ID: 40450070
gotcha, thanks!
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Question has a verified solution.

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

Ready to get certified? Check out some courses that help you prepare for third-party exams.
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

581 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