Restore Database

Vignesh Mani

11y1.1k

How to Restore DB from SQL SERVER 2014 [versions 12.0.2000.8] to SQL SERVER 2008 R2 [Versions 10.50.1600.1] ?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Raja T11y ago
Please refer the below link.
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/fef031c1-e4cb-43d7-a8d9-4527a4a2d65e/restore-database-file-from-2008-r2-to-2008-version-failed?forum=sqlservermigration
Rajeesh Menoth11y ago
Hi,

1) Right click your database
2) Task -> Generate Scripts
3) Click Generate Scripts
4) click next button.
5) You can see a Advanced option click that option.
6) Change the option "Script for server version" 2014 sql version to SQL SERVER 2008 R2
7) if u want all details include contents in the table then check the" types of data to script" dropdown show schema change as to schema and data

Check this : http://dba.stackexchange.com/questions/20588/restore-sql-server-2012-backup-to-a-sql-server-2008-database