InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 01:35:26 GMT20http://www.sqlservercentral.com/Forums/Topic1405038-2893-1.aspx[quote][b]David Webb-200187 (1/9/2013)[/b][hr]As far as I know, there is no way to do a backward restore, even if the database was in a compatibility mode that matched the lower version. The compatibility mode impacts how certain sql constructs behave on a database but it doesn't mean that the database is actually internally structured as a database on that native version would be. A 2012 database, no matter what the compatibility mode, is still a 2012 database internally, so a 2008 server wouldn't understand that internal structure or be able to restore it.Best advice is to script out all the objects, create them on the older database, then copy the data.[/quote]Have to agree 100%.Thu, 10 Jan 2013 07:55:54 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic1405038-2893-1.aspx+1 Scripts (create table and etc) out with comptiable to SQL 2008.Thu, 10 Jan 2013 05:59:03 GMTArun-235202http://www.sqlservercentral.com/Forums/Topic1405038-2893-1.aspx[quote][b]David Webb-200187 (1/9/2013)[/b][hr]As far as I know, there is no way to do a backward restore, even if the database was in a compatibility mode that matched the lower version. The compatibility mode impacts how certain sql constructs behave on a database but it doesn't mean that the database is actually internally structured as a database on that native version would be. A 2012 database, no matter what the compatibility mode, is still a 2012 database internally, so a 2008 server wouldn't understand that internal structure or be able to restore it.Best advice is to script out all the objects, create them on the older database, then copy the data.[/quote]+1, couldnt of said it better myself.Thu, 10 Jan 2013 02:06:45 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1405038-2893-1.aspx[quote][b]David Webb-200187 (1/9/2013)[/b][hr]As far as I know, there is no way to do a backward restore, even if the database was in a compatibility mode that matched the lower version. The compatibility mode impacts how certain sql constructs behave on a database but it doesn't mean that the database is actually internally structured as a database on that native version would be. A 2012 database, no matter what the compatibility mode, is still a 2012 database internally, so a 2008 server wouldn't understand that internal structure or be able to restore it.Best advice is to script out all the objects, create them on the older database, then copy the data.[/quote]+1Wed, 09 Jan 2013 16:13:04 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1405038-2893-1.aspxAs far as I know, there is no way to do a backward restore, even if the database was in a compatibility mode that matched the lower version. The compatibility mode impacts how certain sql constructs behave on a database but it doesn't mean that the database is actually internally structured as a database on that native version would be. A 2012 database, no matter what the compatibility mode, is still a 2012 database internally, so a 2008 server wouldn't understand that internal structure or be able to restore it.Best advice is to script out all the objects, create them on the older database, then copy the data.Wed, 09 Jan 2013 15:17:22 GMTDavid Webb-CDShttp://www.sqlservercentral.com/Forums/Topic1405038-2893-1.aspxHi,I initially took backup from SQL Server 2012 (database compatibility mode was set to SQL Server 2008 (100)) but when I try to restore that backup on SQL Server 2008 R2 it is giving me error as "Specified cast is not valid".I would appreciate if anyone can help me or if there is any alternate solution to backup from SQL Server 2012 and successfully restore it on SQL Server 2008 R2, please let me know.Thank you.Wed, 09 Jan 2013 15:10:52 GMTmonilps