• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 55
  • Last Modified:

SQL Server Backup to previous version

Is it possible to make a SQL Server 2014 instance of a database backup that can be restored to a 2012 Instance?
0
Larry Brister
Asked:
Larry Brister
2 Solutions
 
Shaun VermaakTechnical Specialist/DeveloperCommented:
0
 
Scott PletcherSenior DBACommented:
No.  You'd need to use some other mechanism, such as the "Transfer Wizard", iirc, to convert the 2014 db to a 2012 db.  Restores are not backward compatible.
0
 
Larry Bristersr. DeveloperAuthor Commented:
Is Transfer Wizard better than SQL Data Examiner?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Scott PletcherSenior DBACommented:
I don't know.  I don't recall ever using SQL Data Examiner myself.
0
 
Larry Bristersr. DeveloperAuthor Commented:
Then can I create a copy of the database locally that is the previous version? ANd make a backup of that?
0
 
Scott PletcherSenior DBACommented:
No.  A SQL 2014 db cannot be directly transferred to a SQL 2012 instance except using some type of conversion.
0
 
Larry Bristersr. DeveloperAuthor Commented:
OK
Reviewing all of this and will award points in the next couple of hours
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
You can use the Copy Database Wizard to "downgrade" a SQL Server database version.
Mind that if you follow my article, you'll need to use the SQL Management Object method instead of the detach and attach method.
1
 
Larry Bristersr. DeveloperAuthor Commented:
Sorry for late response.  Was out of country
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Network Scalability - Handle Complex Environments

Monitor your entire network from a single platform. Free 30 Day Trial Now!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now