I am trying to restore a SQL Server 2012 database after I set the compatibility level to SQL Server 2008 by following the instructions as listed on: http://learnsqlwithbru.com/2012/01/11/setting-database-compatibility-level-for-sql-server-2012/
However, the restore still doesn't work and I get "specified cast is invalid". Is there any way I can fix this problem?
Note: I don't want to use a Generate scripts option.