Solved

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

Posted on 2014-11-18
4
197 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
[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
  • 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
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…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how the fundamental information of how to create a table.

707 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