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

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.

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