Sql Server Coversion

you can't, you can NEVER restore from a higher version to a lower version of SQL Server. Your only option is to script out the database and then transfer the data via SSIS, BCP, linked server or scripting out the data

0

Jignesh Trivedi12y ago

No this is not possible, we can move forward... means we can restore the database from 2005, 2008 to 2012 version but not in reverse order.

but there is work round

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

0

Munesh Sharma12y ago

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

0

Karthik M12y ago

Hi Rajesh,

you can take sql server 2012 scripts with data and will execute in 2008

0