Wednesday, February 20, 2013

Can you Restore SQL Server 2012 backup to a SQL Server 2008 database?

No. Error message: Specified cast is not valid. (SqlManagerUI)
You can restore 2008 to 2012, but not backward.