Want a small clarification from our experts in Navision 4. Sir, I have found that my database has consumed 91% of the total database size. I would like to expand my Navision database. Whether I have to go in “File-Database-Expand-Add(KB)” or is any other option for expanding the database. Would like to know whether the said procedure can de done on office hour or I have to log out all users in order to expand the database.
You should never expand the database whilst other users are logged in. The Navision Native database has a version principle that manages versiosn, and allows multi users to do virtually anything. If there is a crash, Navision recovers from errors, And you wont lose data
EXCEPT ---- The version principle for some bizare reason does not function whilst expanding a database. So if anything crashes or goes wrong during an expand, you WILL lose the entire database. Exapnd is the only function in Navision that works like this.
So if you want to expand, log off all users, create a backup, and then expand the database.
If you read the tread again, then you will see that this is regarding the Navision database (aka the native database). Not the SQL database.
You can expend the SQL database by using the ALTER database tool or from your SQL Enterprise Manager. You can also set your SQL database to expand automatically.
But for performance reasons, it is best not to do it automatically. SQL can decide to expand the DB in the middle of some transaction, this means the transaction is suspended until the expansion is finished. Depending on the setup, it can take some time.
So better expand the DB manually when no one is working.