Navigation: Security & Access Management > System Administrator Options: Validate Database This Help File Page was last Modified on 11/17/2018

❑Validating the Micro Key Millennium Series™ Database Structures on a routine basis is important:

•This process will analyze the database for corruption and report the table(s) affected by it.

✓Validating your database on a regular basis is very important.

✓Any reported problems can then be reported to Technical Support for diagnosis, resolution and/or correction.

 

•It is recommended that you run this process on a machine that is not the Primary server and not the machine running the Live SQL database.

✓It can be run on any workstation (or any of the backup servers).

✓Also see the MKS Validate Utility chapter.

 

❑To Validate the Database Structure(s):

•To access the Validate Database utility:

a)From the Backstage Menu System Select the Maintenance Menu then Select the System Administrator sub-menu, or

b)From the Quick Access Menu, Select the Maintenance Menu then Select theSystem Administrator sub-menu

✓Then, Choose the Validate Database option

 

Validate Database dialog

 

✓Also validate the MKMS database - Check this box to include MKMS.db in this validation process (recommended).

✓Start - To start the validation of the MKMSDefault.db database (and MKMS.db, if this is also selected), Click the Start button.

 

 The Validate Database progress list

 

✓The process continues until completion.

 

•Close - Click the Close box to return to the Main Menu.

✓If any Database Structure error message(s) relating to any table appears:

▪Perform a "screen shot" of the error message and print it.

▪Report these to Technical Support for diagnosis, resolution and/or correction.