In SQL Server 2008 R2, I tried to restore a database backup that has been taken from SQL Server 2012, by doing the following:
But unfortunately, After clicking OK. I got the following error
Specified cast is not valid
The database restore operation is only allowed as a move forward that means, you can restore the database from 2005 or 2008 to 2012 version but it’s not applicable in reverse order.
The simple solution to achieve that is to use “Script and Data Generator Wizard” to create T-SQL script, then run it at the destination SQL Server with earlier version.