Backing up Perforce ALM databases

Back up the Perforce ALM database and project databases regularly.

ALM native server database

1. Stop the Perforce ALM Server.

2. Back up the contents of the TTServDb directory on the server computer. Following are the default locations:

  • Windows—C:\Program Files\Perforce\Perforce ALM\TTServDb
  • Linux—/var/lib/Perforce ALM/TTServDb
Only copy the project subdirectories if you are using TestTrack 2011.2 and earlier and want to back up projects at the same time.

3. Back up the storageKeys directory in the Perforce ALM application directory. Following are the default locations:

  • Windows—C:\Program Files\Perforce\Perforce ALM\storageKeys

  • Linux—/var/lib/Perforce ALM/storageKeys

4. Restart the Perforce ALM Server.

ALM native project databases

Perforce ALM (all versions), Helix ALM (all versions), or TestTrack 2012 - 2016.1

Use the Native Database Backup Command Line Utility to safely back up ALM native project databases without stopping the server. To learn more, see Backing up ALM native project databases using the backup utility.

Download the utility from the Add-ons page.

TestTrack 2011.2 and earlier

Each project is stored in a subdirectory in the TTServDb directory. Projects may be stored in other locations depending on your configuration.

1. Stop the ALM Server.

2. Copy the directories to back up.

  • To copy all projects, copy the TTDbs directory and all subdirectories. This also copies the server database.
  • To copy an individual project, copy the appropriate directory in the TTDbs directory and all subdirectories.

3. Restart the ALM Server.

PostgreSQL and SQL Server server and project databases

If the server database or projects are stored in a different RDBMS, ask your DBA for help with backups.

When you back up the server database and projects from the RDBMS, also back up:

  • Project directories and subdirectories on the ALM Server, which contain files such as attachments, report stylesheets, and RSA keys.
  • The storageKeys directory in the Perforce ALM application directory, if it exists. Following are the default locations:
  • Windows—C:\Program Files\Perforce\Perforce ALM\storageKeys

  • Linux—/var/lib/PerforceALM/storageKeys

Make sure you stop the server before backing up data.