companies missing after SQL restore

Debbie140Debbie140 Member Posts: 52
edited 2008-04-08 in SQL General
I have a client that had a disk failure and had to restore Navision.
They had 2 types of backup. navision and SQL.

The SQL is approx 70GB (something wrong there I think!) The navision backup only has about 15 2GB files so it does not seem large enough and we assumed it was not a full backup. On restoring the Navision backup there were a lot of tables missing confirming this theory.

After restoring the SQL backup once the licesne had been uploaded you can log in. however when you go to the company list to open a company it is empty.

I am going out to see the client but wonedered if anyone has any thoughts so I'm not going in blind.




  • kinekine Member Posts: 12,562
    1) You cannot compare size of NAVbackup and SQL backup - NAV is backing up just data and objects, SQL is backing up everything (including indexes and SIFT tables which can be 50% of database if the DB is overindexed).

    2) If restore of NAV backup succeeded, there must be all restored. Just check, that zoou are really restoring the backup into clean DB, else some tables and objects will not be restored.

    3) If the SQL backup was full backup, and was restored successfully, all is there. Just check the permissions, synchronize the permissions, check it with sys_admn user etc. to be sure what is the problem. You can use SQL Management studio or another SQL tool to check if the tables and data are there...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • ara3nara3n Member Posts: 9,253
    Also to make sure that you have fully restored the backup is to click on tools and choose restore. It will ask you if you want to continue restore. Click yes.

    After it finishes, it will ask to restore another backup and then you can click cancel.
    Ahmed Rashed Amini
    Independent Consultant/Developer

  • krikikriki Member, Moderator Posts: 9,079
    [Topic moved from Navision forum to SQL General forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Sign In or Register to comment.