Restoring Backup from SQL Server 2012 to SQL Server 2008R2

Yaduvanshi

Hi all,

I am facing a issue ,that all the NAV development of my client has done on SQL 2012 , and my client is using SQL 2008R2 version. as from higher to lower I am not being able to Restore it and Giving me ERROR- The SPECIFIED CAST IS NOT VALID(SQLMANAGERUI).and I don't know how to fix it.
So please give me idea how can I restore backup in DB of SQL 2008 R2 from SQL 2012.

Regards
Yaduvanshi

ara3n

ran into the same issue. i had to upgrade my sql server to 2012.

Shedman

If you use NAV 2009 R2 or below, you could create a NAV Backup (.fbk), create a new SQL database from the Classic Client and restore your .FBK in that.

I don't think it's possible to restore a SQL 2012 .BAK file in a SQL 2008 intance, as SQL 2012 has modified the database in ways that SQL 2008 has absolutely no knowledge of ...

kriki

It is impossible to restore a SQL backup done using a more recent SQL Server version into an older SQL server version.

pdj

Shedman wrote:

If you use NAV 2009 R2 or below, you could create a NAV Backup (.fbk), create a new SQL database from the Classic Client and restore your .FBK in that.

Agree, except you can also do it NAV2013, but not in NAV2013R2.

Yaduvanshi

Hi.... I have done that by Exporting All FOB Objects from SQL Server 2012 and Imported them through NAV which is on SQL 2008R2.
and its running fine. Is it the RIght way I Did

pdj

Well, that gives you an identical database, but without any data.
If that is ok for you, then your problem is solved :-)

davmac1

The Microsoft NAV team blog says they should be releasing the backup for NAV 2013R2 very soon.
http://blogs.msdn.com/b/nav/archive/2014/03/07/coming-soon-exporting-and-importing-companies-and-other-data.aspx

robert001

Hi All,

If this is still usefull:
- this can be achieved in NAV 2015 with powershell commands export-navdata and import-navdata

Cheers,
Robert