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.
To confirm that automatic backups are working, select About from the Help menu in the Console and review the Server Diagnostic Details section, which shows whether backups are enabled and the result of the most recent backup.
Backup Fails with "Access is denied"
If the automatic backup fails with an error such as "Cannot open backup device ... Operating system error 5 (Access is denied)" (message ADT005123), the account that the SQL Server Agent runs under does not have permission to write to the backup folder. Note that it is the SQL Server Agent(not the adTempus service) that writes the backup file.
To resolve the problem, find the Log On account for the "SQL Server Agent (ADTEMPUS)" service in the Windows Services tool, then grant that account Read and Write permission on the backup folder named in the error message.
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.