Testing the database
Running periodic tests on the Dynamics NAV database must essentially be a part of the organization's periodic database management plan.
The backup process in Dynamics NAV has a built-in basic database test, which runs during the backup process.
To run a database test on the Dynamics NAV database, go to File | Database | Test.
Starting the test
The following options can be selected before starting the test:
Minimum: This is the test that the Dynamics NAV backup process automatically initiates. This includes testing primary keys and data, and also testing all BLOB fields in the database. When run, this test validates the data in the primary keys, which is readable and sorted appropriately, and all the BLOB fields in the database can be read.
 |
Normal: In addition to the checks done in the Minimum DB tests, this test also checks for secondary keys and space allocation.
 |
Maximum: This test includes testing for field relationships in addition to the tests available in Normal...
