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. Copy 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/HelixALM/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. 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, make sure to also back up the project directories on the Helix ALM Server that contain attachments and report stylesheets. Copy the project subdirectories to back them up.

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