How to Restore SQL Server 2012 Database Backup to SQL Server 2008?

Ideally, there is no way you can restore MS SQL Server 2012 database to SQL Server 2008 even if the database was in a compatibility mode matching the lower version. Regardless of the compatibility mode chosen, SQL Server 2012 database is still a 2012 database internally. Hence, SQL Server 2008 wouldn't be able to understand internal structure of MS SQL Server 2012 database and database wont' be restored.

The best bet is to create an empty database on SQL Server 2008, run Generate Scripts wizard in Management Studio to script the schema and data. Following are the steps.

IMPORTANT : This method is only applicable if your database size is under couple of hundred MBs. If you script out big databases with schema and data, the script might get huge and could not handled by Management studio or SQLCMD.

  1. Connect to MS SQL Server 2012 using Management Studio.
  2. Expand the Databases and right click on the database you want to script. Select Tasks  >> Generate Scripts option.

    Generate Script

  3. Skip the introduction screen and click on Choose Objects option.

    Choose Object

  4. Keep checked an option of script entire database and all database objects and click on Set Scripting Options.
  5. On the specify how scripts should be saved or published page, click Advanced.

    Generate Publish Script


  6. Under General, locate Types of data to script and change it from Schema only to Schema and dataChange Script for Server Version from SQL Server 2012 to SQL Server 2008. Make sure you set the correct target version of SQL Server 2008 here.

    Types Of Data

    Set Scripting Option

  7. Click on OK. Click on Next 2 times and then Finish.



  • 1 Users Found This Useful

Was this answer helpful?

Related Articles

How to Fix Error "Could not allocate space for object 'X' in database"?

Error Message Could not allocate space for object 'dbo.ABC_XYZ_XYZ'.'AB__ABC_XYZ__XYZ' in...

How to Install Advanced Features on Existing Instance of MS SQL Server?

If you have chosen MS SQL Server to be installed in Windows VPS while placing an order, you'll...

How to use MSSQL Activity Monitor to find the most expensive query?

A slow and long running SQL query execution consumes much processor, memory, and disk of your...

How to install SSRS (SQL Server Reporting Service) on MSSQL 2014 Express Edition?

SQL Server Reporting Services is used for creating, publishing, and managing reports, and...

Microsoft SQL Server 2016 Recommendation

The SQL Server 2016 Express is the latest data management system from the Microsoft. Like the...