Summary

If you are using the default SQL Server Express database engine for adTempus, adTempus creates a database backup automatically each day around 1:30 AM. This article explains how to change the settings for the automatic backup.

More Information

The automatic backup cannot be configured through the adTempus Console, but some settings can be changed by setting options in the Registry on the computer where the adTempus service is running. Note that any changes you make will not take effect until the adTempus service is restarted.

The following settings are stored under Registry key "HKEY_LOCAL_MACHINE\Software\Arcana Development\adTempus\options". If the "options" key does not exist, you will need to create it.

Each setting is controlled by a string (REG_SZ) value created under the options key. You will need to create each value, as they are not present by default. Be sure to create each value as a STRING value. For example, to set the "Maintenance:DoDatabaseBackup" option, create (or modify if it already exists) the "Maintenance:DoDatabaseBackup" value.

Option Name Description
Maintenance:DoDatabaseBackup Controls whether the backup is performed. Set to "0" to disable backups. Set to "1" to enable backups. If no value is present, the backup will be performed.
Maintenance:BackupTime Sets the time at which the backup will occur. Specify the time in the form "HH:mm". For example, "02:45" to run the backup at 2:45 AM, or "16:30" to run it at 4:30 PM.
Maintenance:LogBackupSuccess Determines whether adTempus will log a message when the backup succeeds. If the value is set to "1", adTempus will log an informational message to the computer's Event Log and also to the Alerts log in adTempus indicating that the backup ran successfully. If this value is set to "0", adTempus will log a message only if the backup fails. Default value: "0".

You can change where the automatic backup is stored by setting the DatabaseBackupPath option.

Note: This option is set in a different location than the options described above.

The following settings are stored under Registry key "HKEY_LOCAL_MACHINE\Software\Arcana Development\adTempus".

Each setting is controlled by a string (REG_SZ) value created under the key. You will need to create the value, as is is not present by default.

Option Name Description
DatabaseBackupPath Sets the path where the backup file will be written. This must be on a local drive (mapped network drives and UNC paths are not allowed) because the backup is performed by SQL Server, which is running under the Local System account and does not have access to remote resources. If no value is specified, the backup is written to the "data\backup" directory under the adTempus program directory.

See Also

See the Backing Up and Restoring adTempus Data topic in the adTempus help for more information about database backups.