Does navision backup lock access to tables?

arcull

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:

kine

Are you using Navision server or MS SQL?

arcull

I am using native Navsion database server.

kriki

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).

arcull

OK, thanx guys