Backup and Restore of Enabler configuration and data

The Enabler stores all configuration and accumulated data in an SQL Database named EnablerDB.

Backup

As part of the default installation a batch file C:\Enabler\nightly70.bat is installed. This can be run at anytime to produce a backup of the entire database in:

C:\EnablerDb\Enabler.dmp

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:

1. Install the Enabler software following the installation instructions.

2. Stop all applications that have a connection to the Enabler Database. To restore there must be no open connections to the SQL database.

3. Stop the pump server using the Control Panel - Services (more info).

4. 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
   
   

5. 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
   
   

6. Restart pump server and applications.

Uninstallation

Click here for further information on Uninstalling Enabler before a Fresh Installation..

Specific Restore 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 would be used if the database somehow failed to operate and needed to be restored from the last backup:
1. 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:
1. Close the forecourt and shutdown Enabler Pump Server
2. Run the backup script to ensure the backup file is up-to-date.
3. Copy the backup file Enabler.dmp from the old PC to C:\EnablerDB\ on the target PC.
4. 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:
1. 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.
1. Prepare the target computer by installing the old or target Enabler software.
2. On the old system:
• Close the forecourt and shutdown Enabler Pump Server on the old system
• Run the backup script to ensure the backup file is up-to-date.
3. Copy the backup file Enabler.dmp from the old PC to C:\EnablerDB\ on the target PC.
4. Follow the 'Restore' steps as described above.
5. 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).