Backing up Helix ALM databases

Back up the Helix ALM Server database and project databases regularly.

Helix ALM native server database

1. Stop the Helix ALM Server.

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

Windows—C:\Program Files\Perforce\Helix ALM\TTServDb
Linux—/var/lib/Helix ALM/TTServDb

Note: 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 Helix ALM application directory. Following are the default locations:

Windows—C:\Program Files\Perforce\Helix ALM\storageKeys
Linux—/var/lib/Helix ALM/storageKeys

4. Restart the Helix ALM Server.

Helix ALM native projects

Helix ALM (or TestTrack 2012 - 2016.1)

Use the Native Database Backup Command Line Utility to safely back up project databases without stopping the Helix ALM Server. 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 Helix 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 Helix ALM Server.

Oracle, 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 Helix ALM Server, which contain files such as attachments, report stylesheets, and RSA keys.

The storageKeys directory in the Helix ALM application directory, if it exists. Following are the default locations:

Windows—C:\Program Files\Perforce\Helix ALM\storageKeys
Linux—/var/lib/Helix ALM/storageKeys

Note: Make sure you stop the Helix ALM Server before backing up data.