Restoring Backup from SQL Server 2012 to SQL Server 2008R2

Yaduvanshi
Yaduvanshi Member Posts: 23
edited 2015-02-11 in NAV Three Tier
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

Comments

  • ara3n
    ara3n Member Posts: 9,258
    ran into the same issue. i had to upgrade my sql server to 2012.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Shedman
    Shedman Member Posts: 194
    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
    kriki Member, Moderator Posts: 9,127
    It is impossible to restore a SQL backup done using a more recent SQL Server version into an older SQL server version.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • pdj
    pdj Member Posts: 643
    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.
    Regards
    Peter
  • Yaduvanshi
    Yaduvanshi Member Posts: 23
    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
    pdj Member Posts: 643
    Well, that gives you an identical database, but without any data.
    If that is ok for you, then your problem is solved :-)
    Regards
    Peter
  • davmac1
    davmac1 Member Posts: 1,283
    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
    David Machanick
    http://mibuso.com/blogs/davidmachanick/
  • robert001
    robert001 Member Posts: 3
    Hi All,

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

    Cheers,
    Robert

Categories