Backing up and restoring TestTrack databases is simple once you know where all the files are located. TestTrack includes a server database and the project databases.

The server database includes a set of files that manage licenses, the database list, and other server options. This data can be easily replaced but should still be backed up with the rest of your data.

• When running on Windows, the server database files are located in the TTServDb subdirectory of the TestTrack application directory.
  
  
• When running on Linux or Solaris, the server database files are located in the following directory:/var/lib/TestTrack/TTServDb/*
  
  
• When running on Mac OS X, the server database files are located in the following directory:/Application/TestTrack/TTServDb/*

The project database files are stored in a subdirectory of the TTServDb directory named TTDbs. Each database is saved in a separate directory.

Backing up databases

1. Stop the TestTrack Server. In TestTrack 2008 and later, you can also lock projects to while you perform maintenance. To lock a project, in the TestTrack Client, choose Tools > Administration > Lock Project.
2. Recursively copy the TTServDb directory or the TTDbs directory.
3. Restart the TestTrack Server and unlock the project after the backup is complete.

Database Backup Example (Linux)

cp -R /var/lib/TestTrack/TTServDb/TTDbs/SampleDB/* /tape/bkup

Full Backup Example (Linux)

cp -R /var/lib/TestTrack/TTServDb/* /tape/bkup