Solved

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

Posted on 2014-11-18
4
191 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 500 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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

680 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