Solved

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

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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Error in WHERE Clause 5 39
SQL Query stumper 3 36
Extract string portion 2 14
T-SQL:  Carrying a Figure from One Row to the Next 14 31
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
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…

910 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

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now