How to restore SQL Server 2012 database on SQL Server 2008 R2

Restoring Backups of SQL Server 2012 databases on SQL Server 2008 R2 

Applies to:

  • SQL Server 2012
  • SQL Server 2008 R2
 

Generating Scripts For SQL Server 2012 in compatibility mode for SQL Server 2008 R2

For taking backup:

  1. Open SQL Server Management Studio
  2. Go to specific database whose backup is to be taken
  3. Right Click, Go to "Tasks" >> "Generate Scripts"
  4. In "Set Scripting Options", click on "Advanced"
  5. Select "Script For Server Version" as "SQL Server 2008 R2"
  6. Select "Types Of Data To Script" as "Schema And Data"
  7. Generate Scripts

For Restoration:

  1. Login to your database on server using the SQL Server Management Studio 
  2. Click on New Query 
  3. Run the script from there, It will restore data with schema on SQL Server 2008 R2
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to optimize database via phpMyAdmin in cPanel?

1. Log into your cPanel account.2. In the "Databases" section, click on "phpMyAdmin" Icon. 3. In...

How to export database table via phpMyAdmin in cPanel?

1. Log into your cPanel account.2. In the "Databases" section, click on "phpMyAdmin" Icon. 3. In...

How to add a user to a database and add privileges?

1. Log into your cPanel account.2. In the "Databases" section, click on "MySQL Databases"...

Can I connect to SQL database using SQL Server Management Studio?

Yes, you can use Microsoft SQL Server Management Studio to remotely connect with your database on...

[PLESK] How to Back and Restore Microsoft SQL Server database

With Parallels Plesk Panel, you can back up and subsequently restore the databases, database user...