Validate Database

This Help File Page was last Modified on 11/17/2018

<< Click to Display Table of Contents >>

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

 

HelpFilesValidateDatabase

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.

 

HelpFilesValidateDatabaseInProgress

 The Validate Database progress list

 

The process continues until completion.

 

Close - Click the Close HelpFilesCloseBoxbox 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.