Does navision backup lock access to tables?

arcull
arcull Member Posts: 191
edited 2006-01-26 in Navision Attain
Does anyone know if navision locks tables while making backup? I know it does while making restore. I am asking becaues I plan to make backups while users are still working on server. Thanx for answer. :roll:

Comments

  • kine
    kine Member Posts: 12,562
    Are you using Navision server or MS SQL?
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • arcull
    arcull Member Posts: 191
    I am using native Navsion database server.
  • kriki
    kriki Member, Moderator Posts: 9,121
    Navision DB does not lock the tables.
    Navision works with the version principle. It makes a version of the DB and then it backs up this version while others are writing into the DB. These records are also stored in the DB until the backup is finished, then the old versions of the records are deleted.
    So important things to remember:
    -Have enough free DB-space for the newer-version records.
    -Enable the COMMIT-cache, without this it slows down everything. (BTW:ALWAYS enable the COMMIT-cache).
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • arcull
    arcull Member Posts: 191
    OK, thanx guys

Categories