RESTORE NAVISION BACKUP IN SQL USING SQL MANAGEMENT CONSOLE

anilswami
anilswami
edited 2009-10-04 in NAV/Navision Classic Client
CAN ANY ONE TELL ME HOW TO RESTORE NAVISION BACKUP IN SQL USING SQL MANAGEMENT CONSOLE?

Comments

  • Slawek_Guzek
    Slawek_Guzek
    Navision backup (fbk file) can only be restored using NAV client.

    Slawek
    Slawek Guzek - www.yitron.co.uk
    Business Central, MS SQL Server, Wherescape RED;
  • anilswami
    anilswami
    how can i restore a fbk file in sql database using sql management console?should i take the backup through sql and then restore?? plz let me know
  • kine
    kine
    anilswami wrote:
    how can i restore a fbk file in sql database using sql management console?should i take the backup through sql and then restore?? plz let me know
    Do you read the answers? You CANNOT restore FBK through SQL tools. You need to use NAV client. If you want to use SQL tools, you need to create SQL backup (in most cases the file have name .bak) through SQL console and restore this...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • anilswami
    anilswami
    Actually i have a .bak file which was present on a different SQL Server(2008). i now want to restore on my machine i have installed the sql(2008) and now i want to create a new database but i am not able to restore it.can you provide me the steps to do it.
  • DenSter
    DenSter
    In Books Online (Start, All programs, SQL Server 2008, Documentation and Tutorials, Books Online) there is an article that explains the whole thing. The article is called "How to: Restore a Database Backup (SQL Server Management Studio)".
    Daniel Rimmelzwaan
    RIS Plus, LLC

Categories