Backing Up and Restoring Data

To reduce the chances that adTempus configuration or history information is lost in the event of a hardware or software failure, it is important to back up your adTempus data frequently.

This topic covers database backups, which are used to recover your entire adTempus database in the event of a failure. Database backups cannot be used to restore selected jobs or other objects. Configure automatic snapshots to allow you to recover data at a more granular level.

Backing Up Data

adTempus data resides in two locations:

• Captured files are stored in the "CapturedFiles" folder under the adTempus instance directory (e.g., "c:\program files\Arcana Development\adTempus\instances\default\data\CapturedFiles"). If captured file data is important, be sure your backup routine includes this folder.
• All other adTempus data (job definitions, history, etc.) is stored in the adTempus database, which should be backed up regularly as described below.

If you are using the default SQL Server Express database engine installed with adTempus, adTempus automatically backs up your database each day at about 1:30 AM (backup settings are available in the Server Options window). The database backup file is saved in the "backup" folder under the adTempus instance directory (e.g., "c:\program files\Arcana Development\adTempus\instances\default\data\database\backup"). You should ensure that your backup routine includes this folder.

If you are using your own database server to host the adTempus database, adTempus will not automatically create backups by default. Therefore you must make sure that your existing database server backup routine includes the adTempus database, or configure adTempus to perform the backup.

In addition to automated backups, you can use the adTempus Database Utility to manually back up the database at any time.

Restoring Data

Restoring an adTempus installation involves restoring both the adTempus database and the CapturedFiles directory. (If you do not restore the CapturedFiles adTempus will operate normally, but you will receive an error if you try to view a captured file.)

Note that restoring the adTempus database restores your configuration and history to the state they were in at the time the backup was taken; any subsequent changes are lost.

Before restoring the adTempus database and files, stop the adTempus service.

If the backup was performed on your own database server, you should use the tools on that server to restore the database.

If the backup was produced automatically by adTempus, or using the adTempus Database Utility, use that tool to restore the database.