Enabler Backup and Restore

The Enabler stores all configuration and accumulated data in an SQL Database named EnablerDB. This article describes how to do a backup or restore of this database.

For information about migration from one PC to another, please refer to:

FAQ: How do I migrate Enabler from one PC to another

Backup

As part of the default installation a batch file C:\Enabler\nightly70.bat is installed. Please run this batchfile to produce the latest backup of the entire database in:

C:\EnablerDb\Enabler.dmp

or

C:\EnablerDb\Enabler_YYYYMMDD.dmp

NOTE: The actual filename of the backup will depend on the Enabler Release installed in your system. The installation also schedules this batch file to run at 1am everyday to automatically backup the entire database.

Restore

To restore an entire Enabler system, including software do the following steps:

Install the Enabler software following the installation instructions.
Stop all applications that have a connection to the Enabler Database. To restore there must be no open connections to the SQL database.
Stop the pump server using the Control Panel - Services (more info).
Restore the database over the default database. Below are instructions on doing this using the OSQL utility from MSDE:
```
   C:\> osql -E
   1> restore database enablerdb from disk = 'C:\Enabler\Enabler.dmp'
   2> go
   1> quit
```
Access privileges must now be reapplied to the EnablerDB Database. This can be done using the SQL script AfterRestore.sql
To run this from a command prompt do the following:
```
   C:\> cd enabler
   C:\Enabler> sql70 afterrestore
```
Restart pump server and applications.

Uninstall

For more information about this refer to our article:

FAQ: Uninstalling Enabler before a Fresh Installation

Example Scenarios

Some examples of back up and restore scenarios are described below. Please note that Enabler database schema is automatically updated by The Enabler Setup program when doing a full or patch install. Database schema changes are documented in a the Enabler release notes.

How to restore a database backup on an existing Enabler installation (no database upgrade). This process can be used if the database stops working and cannot be accessed. To restored the database from the last backup:

Follow the 'Restore' steps as described above.

How to restore a database backup onto a different PC (no database upgrade, assumes Enabler is already installed on the Target PC). This process should be used when replacing or upgrading the PC running The Enabler:

Close the forecourt and shutdown Enabler Pump Server
Run the backup script to ensure the backup file is up-to-date.
Copy the backup file Enabler.dmp from the old PC to C:\EnablerDB\ on the target PC.
Follow the 'Restore' steps as described above.

How to upgrade a database on an existing Enabler installation (no relocation, no restore). This is a normal part of software upgrade. Refer to the installation instructions for more information about software upgrade:

Run the Enabler installation or upgrade script (this will modify the database schema but not the database data)

How to relocate and then upgrade a database. This process applies when a hardware (PC) upgrade and Enabler Software Upgrade are done at the same time.

Prepare the target computer by installing the old or target Enabler software.
On the old system:

Close the forecourt and shutdown Enabler Pump Server
Run the backup script to ensure the backup file is up-to-date (wait for it to complete).

Copy the backup file Enabler.dmp from the old PC to C:\EnablerDB\ on the target PC.
Follow the 'Restore' steps as described above.
Run the Enabler Setup (or upgrade script) for the version you plan to use. This step is required to upgrade the database schema for compatibility with the new Enabler software (while preserving the database data).