How to use the Validation Tool for the Symantec Endpoint Protection Manager Database.

Article:TECH104892  |  Created: 2008-01-08  |  Updated: 2012-09-13  |  Article URL http://www.symantec.com/docs/TECH104892
Article Type
Technical Solution


Issue



Where to find, and how to use the "dbvalidator" database validation tool?


Solution



The Database Validation tool:
If an issue is suspected with the Symantec Endpoint Protection Manager (SEPM) database, the "Database Validation" tool can be used to assist in diagnosing the problem.

  • The dbvalidator should always be run from the #1 SEPM of a site.
     
  • The batch file, "dbvalidator.bat", is located by default in the following location:
    C:\Program Files\Symantec\SymantecEndpoint Protection Manager\Tools.
  • This tool creates a log file with the following name:
    "dbvalidator.log", which is placed in the C:\Program Files\Symantec\SymantecEndpoint Protection Manager\tomcat\logs folder.


To run the Database Validation tool:
Note: Run the dbvalidator from the #1 SEPM of the site

  1. Go to Start > Run
  2. Type CMD
  3. Click Ok
  4. Change directory to your tools installation folder, by typing:
    cd C:\Program Files\Symantec\Symantec Endpoint Protection Manager\Tools

  5. Type of the following command to run the batch file:
    • dbvalidator.bat


The tool will create a log file which is, by default, located here: C:\Program Files\Symantec\Symantec Endpoint Protection Manager\tomcat\logs\dbvalidator.log

One of the following messages is displayed at the command prompt dependent upon whether the database has passed validation or not:

    • If the database is valid, you see the following message:
      "Database validation passed."
    • If the database is invalid, you see the following message:
      "Database validation failed. Please check the log file for more details."
    • If an error occurs, you see the following message:
      "Some error occurred. Please check the log file for more details."



Technical Information
If database validation fails, you will either need to restore from a known good database backup, or uninstall the manager, remove the database during uninstall process, then reinstall the management console, creating a new database. To reconnect existing Symantec Endpoint Protection clients to the new management console, please see the document 'Best Practices for Disaster Recovery with Symantec Endpoint Protection' and follow the instructions for disaster recovery without a database backup. Alternately, contact Support to obtain the appropriate SylinkReplacer tool for the version of SEP that is running in the environment.

 




Legacy ID



2008050810375848


Article URL http://www.symantec.com/docs/TECH104892


Terms of use for this information are found in Legal Notices