Can I restore my SQL Server 2012 database backup to SQL Server 2008?

1136685 pts.
Tags:
SQL Server 2008
SQL Server 2012
This probably isn't possible but can I restore my SQL Server 2012 database backup to SQL Server 2008? I'm assuming I can only go forward, not backup.
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi,

Before any action, please take the updated backup of the database.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Elizine
    Right click on the database in the 2012 SQL Management Studio, and choose "Tasks -> Generate Scripts". Click past the welcome screen, choose "script entire database and all database objects". On the "specify how scripts should be saved" page, click "advanced". Under "General" in the pop up properties page, change "Types of data to script" from "Schema only" to "Schema and data", and change "Script for Server Version" from "2012" to "2008".

    But remember you will have to check everything manually at application level since those differ highly in SQL server 2012 and SQL server 2008.
    1,145 pointsBadges:
    report
  • geemamoore

    As I know there is no way to do backward restore even if the database is in compatibility mode that matched the lower version. This mode impacts how SQL constructs behave on a database but it doesn’t matter that the database is actually internally structured a database on the native version would be. A 2012 database that is doesn’t mean what the compatibility mode, is still a 2012 database internally.  This means you can only move database from 2005 or 2008 to 2012 version but cannot do it in reverse order. 

    365 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: