Hello,

We do have few databases which are running on MS SQL 2012 server and we would like to migrate the database to MS SQL 2008R2.

Please let me know the steps for migration and issues which we will have to encounter and how to handle the same.

Thanks ,

Sriram Ganapathy

What you ar actualy saying is to downgrade SQl Server 2012 to 2008 r2. direct downgrade is not possible. Please refer below link how to do manual installation and then move data from 2012 to 2008 r2

https://www.mssqltips.com/sqlservertip/2810/how-to-migrate-a-sql-server-database-to-a-lower-version/

you cant  restore 2012 back up set on sql server 2008.as backward compatability is not support in sql server

you can have 2 alternaticves

1 generate script with data

2 generate tables script execute and use BCP Command to out and In to move the data