Restore Database

Question

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

Raja T · Answer

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 Menoth · Answer

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