February 4, 2014
Tips for Backing Up Your TestTrack Data
As January comes to a close, you may have already given up on your New Year’s resolutions, but keeping your TestTrack data backed up is an important one to keep! If a hardware problem, data loss, or other issue occurs, a current backup can get your organization up and running again in TestTrack quickly. If you do not currently have a TestTrack backup strategy, now is the time to put one in place. Or, if you already back up your data, take a few minutes to refresh your memory about the options available for backups and revisit your strategy. Keep in mind that your backup strategy depends on the type of database you use for your TestTrack Server and project databases, and your hardware and software environment. Here are some tips to help make sure you are on the right track with your TestTrack backup strategy.Email sign up
1. Establish a regular backup routineDetermine an appropriate frequency to back up your TestTrack data. Work with your IT organization to determine the days and times to perform backups. You may want to run backups when TestTrack usage is low, such as overnight, to avoid performance issues. The TestTrack Server database contains information displayed in the TestTrack Server Admin Utility, which does not change as often as project data. You may want to back up the server database less frequently than the project databases.
2. Use an appropriate backup methodThe backup method you use depends on the database type (native or RDBMS) and purpose (server or project). You may automate backups using a script or batch file.
TestTrack native databases (SQLite)
- TestTrack Server database: Stop the TestTrack Server and then copy the contents of the TTServDb directory in the TestTrack application directory on the server computer. You only need to back up the subdirectories if you are using TestTrack 2011.2 and earlier. When the backup is complete, restart the TestTrack Server.
- TestTrack project databases: If you use TestTrack 2012 and later, use the TestTrack Native Database Backup Utility on the server computer. It is a command line utility you can use to back up project databases without stopping the TestTrack Server. The utility does not back up the server database. You need to follow the instructions above for backing up the server database. Information about using the utility is here. If you use TestTrack 2011.2 and earlier, stop the TestTrack Server, copy the subdirectories in the TTServDb, and restart the server.