BVE Database Maintenance on Windows

Backing up the Provisioning Database (Online)

To back up the Provisioning Database while Traverse is operating, open a command window and execute the following commands:

C:

cd <TRAVERSE_HOME>\apps\poet\bin

ptxml -export -file C:\temp\provdb.xml -server localhost -base provisioning -overwrite

This creates a backup of the database in c:\temp. You can then archive/copy the provdb.xml backup file to tape or other backup media.

Backing up the Provisioning Database (Offline)

To back up the Provisioning Database while offline (if Traverse is not operating), do one of the following:

• Copy <TRAVERSE_HOME>\database\provisioning and <TRAVERSE_HOME>\database\provisioningdict directories to a backup location.
• Export the database to a .xml file.

To create an XML export of the database while offline, execute the following commands:

1. Shut down all Traverse components.
2. Execute the following commands:

C:

cd <TRAVERSE_HOME>

utils\databaseUtil.pl --action export --file C:\temp\provdb.xml

This creates an exported XML copy of the Provisioning Database in C:\temp. Copy provdb.xml to a safe location.

Restoring a Copy of the Provisioning Database

To restore a copy of the Provisioning Database that was previously exported to XML, perform the following steps:

1. Shut down all Traverse components.
2. Execute following commands:

C:

cd <TRAVERSE_HOME>

utils\databaseUtil.pl --action import --file c:\temp\provdb.xml

If the provisioning and provisioningdict directories were copied while Traverse is offline, then you need to shut down Traverse, copy the two directories back into the /database folder in <TRAVERSE_HOME>, and start all components.

Repairing the Provisioning Database

To repair a corrupted Provisioning Database, perform the following steps:

Note: Consult with Kaseya Support before using these commands:

1. Navigate to Start > Programs > Traverse > Traverse Service Controller.
2. Clear Provisioning Database, Data Gathering Engine, Web Application and BVE API.
3. Click Apply to stop the specified services.
4. Open a command window and enter:

cd <TRAVERSE_HOME>

apps\poet\bin\ptadmin -check database\provisioning

apps\poet\bin\ptadmin -repair database\provisioning

apps\poet\bin\ptadmin -reorg database\provisioning

Note: If you receive any errors, contact Kaseya Support before attempting to restart Traverse.