Native Navision Database Size Error

demekou
demekou Member Posts: 6
edited 2009-08-22 in NAV/Navision Classic Client
After a server crash, we get the following error on trying to start the Navision Database:

The length of database file (recorded in the file itself) is different from the lemgth recorded by the operating system.

and the database cannot be opened. I tried opening the database in single user mode and using dbreadonly=yes, but still the same error is given. Please note that the size of the fdb file reported by Windows is indeed wrong - Windows reports 56GB whereas the correct size should be something like 3GB.

Can you please suggest of any ways to open this database? Also note that we don't have any recent backups, so it really is very important to be able to recover this database.

Regards,
Demetris Kouvaros

Comments

  • jm
    jm Member Posts: 156
    Hi,
    try to start your client with the parameter "dbreadonly=yes", then make a
    backup and rebuild your database with this backup.

    Otherwise you have to contact your NSC, which should contact MBS to support you.

    There is a tool called C/DART to repair a database, but this is very time
    expensive and will be done only by MBS.

    br
    Josef Metz
    br
    Josef Metz
  • kriki
    kriki Member, Moderator Posts: 9,127
    And start taking backups every day (or even more).
    You can use HOTCOPY to do this.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • demekou
    demekou Member Posts: 6
    I've already tried dbreadonly=yes but still I get the same error about the size of the database!

    Any other ideas, apart from resorting to MBS?

    Regards
    Demetris Kouvaros
  • ara3n
    ara3n Member Posts: 9,258
    I believe you need to resort to MBS. The have some internal tools that can help repairing the db. Good luck
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Alex_Chow
    Alex_Chow Member Posts: 5,063
    demekou wrote:
    I've already tried dbreadonly=yes but still I get the same error about the size of the database!

    Any other ideas, apart from resorting to MBS?

    Regards
    Demetris Kouvaros

    Without resorting to Microsoft, you will need to restore a backup and re-enter the transactions as of date.

    Even if you send your DB to Microsoft, it'll take at least a day or 2 before you can get it back.
    Confessions of a Dynamics NAV Consultant = my blog
    AP Commerce, Inc. = where I work

    Getting Started with Dynamics NAV 2013 Application Development = my book
    Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
  • hedegaard
    hedegaard Member Posts: 25
    Are there maybe multiple database files?
    Did you try to copy the fil and open the new copy?

    /regards
    Anders
  • demekou
    demekou Member Posts: 6
    hedegaard wrote:
    Are there maybe multiple database files?
    Did you try to copy the fil and open the new copy?

    /regards
    Anders

    There is only a single database file. I have already copied the fdb file and I get the same error when trying to open the copy.

    It seems the only hope to salvage the database is by sending it to Microsoft. Do you have any idea what Microsoft would charge for this service?

    Regards,
    Demetris
  • sharonkwan76
    sharonkwan76 Member Posts: 1
    Hi,

    I am Sharon. Which facing the problem as per your mentioned. Can you explain and show me in detail how to set the "dbreadonly=yes" parameter. Urgent seek help!

    Thanks & regards
    Sharon
  • kish2007
    kish2007 Member Posts: 64
    Hi Demekou,

    Iam also facing the same problem.Have you go the solution for this error.


    Thanks & Regards,
    kishore...

Categories