Traverse provides utilities for backup, restore, repair, and optimization of the DGE databases. You should back up the DGE databases periodically so that you can restore in the event of serious database corruption or loss.
Some common causes of DGE database corruption include the following:
Traverse server shuts down unexpectedly due to power failure or operating system crash. During a normal system shutdown, the database server will flush all in-memory data to disk and properly close the database tables, but in the event of a power outage or sudden crash, the database server is not able to perform such cleanup tasks.
Running out of disk space on the drive or partition where Traverse is installed. If the database server is not able to allocate disk space to add new data a table or update existing information, the corresponding table may be left in an unusable state. As a rule of thumb, available space should be three times the size of the database directory.
Database tables or files accessed by an external application. This can happen on Windows when anti-virus software is configured to scan files "on access," which may corrupt database tables. You should configure anti-virus software to ignore/exclude any files in the Traverse database directory.
Backup software can also affect database files in a similar manner, so you should exclude the Traverse database directory from automated backup tasks and use only the built-in db_backup utility to back up the Traverse DGE databases.
