Rolling Back an Upgrade

Rolling back an upgrade from adTempus 4 or earlier requires restoring the adTempus database to its earlier state and reinstalling the previous version of the software.

During upgrade, your adTempus license may be updated. It is not necessary to revert to the old license when rolling back an upgrade: the older software will work with the newer license .

Rolling Back a Failed Upgrade

The adTempus upgrade occurs in two phases:

Software Installation

The software is installed or upgraded. If the upgrade fails during this phase, the Windows Installer rolls back the upgrade, and no further action is required.

Database Upgrade

After software installation is complete, the Database Configuration Wizard runs to upgrade the database. This tool will make a backup of the database before making any changes, but it is a good idea to have your own backup as well.

If the database upgrade fails, the tool will attempt to restore the database to its previous state using the backup. At this point the adTempus installation will be in an inconsistent state, with the new software but the old database.

• If you want to resolve the database upgrade problem at this time, leave the software installed and contact us for support.
• If you need to revert to the old version of the software at this point rather than attempting to resolve the upgrade failure, you must uninstall adTempus to remove the new version, then reinstall the old version. Older versions are available for download from the adTempus download archive.

Rolling Back a Completed Upgrade

If the upgrade was completed successfully (software installed and database updated), reverting to a prior version requires restoring the adTempus database to its prior state, removing the new version of adTempus, and reinstalling the old version.

1. Stop the adTempus service.
2. Restore the adTempus database as discussed below.
3. Uninstall adTempus.
4. Reinstall the old version. Older versions are available for download from the adTempus download archive.

Restoring the adTempus Database

Use these steps to restore the adTempus database if necessary.

Be sure to stop the adTempus service before attempting the restore.

Locating the Database Backup

The Database Configuration Wizard will by default make a backup of the adTempus database before upgrading it.

If you are using SQL Server Express to host the database, the backup will be stored on the same computer where adTempus is installed. Generally it will be saved to a folder under the adTempus installation folder: C:\Program Files\Arcana Development\adTempus\instances\default\data\database\backup (replace "default" with the proper instance name if you are not working with the default instance). If the backup file is not found in this location, you can find the location in the log file created by the Database Configuration Wizard. This can be found at C:\Program Files\Arcana Development\adTempus\Instances\default\logs\adtdbconfig.log. Open this file with a text editor and look for a line reporting the "Database backup directory".

If you are using a standalone full SQL Server instance, the backup will be stored in the default backup location for the server or database. Check the SQL Server configuration to find this location.

Restoring in SQL Server Express

If you are using the adTempus instance of SQL Server Express, run the adTempus Database Utility (found on the Start menu) and use Tools > Restore Database to restore the backup file located in the previous step.

Restoring in a Standalone SQL Server Instance

If you are using a standalone SQL Server instance, use your preferred management tool (e.g., Management Studio) to restore the database.