Backing Up and Restoring the Automate Schedule Database

Before You Begin

There are two scripts used to backup and restore the Automate Schedule database (backupdatabase.bat and restoredatabase.bat). Both commands reside in the Automate Schedule root directory on the enterprise server. In order to use the commands, the database service must be running.

Backing Up Automate Schedule

To back up the database, run the following command:

Windows: backupdatabase.bat

UNIX or Linux: backupdatabase.sh

This command creates a backup file of the database named:

automateschedule_YYYYMMDDhhmmss.backup

where YYYY is the year, MM is the month, DD is the day, hh is the hour, mm is the minute, and ss is the seconds.

The script puts the backup file in the root directory of the product.

Restoring Automate Schedule

Notes:

• We highly recommend that you stop the Automate Schedule server before performing a restore.
• The database service must be running.

To restore the database, run the following command:

Windows: restoredatabase.bat

UNIX or Linux: restoredatabase.sh

This command takes a backup file created by the backupdatabase.bat script and restores it to the database.

The file path is passed to the script.

Example:
restoredatabase.bat automateschedule_20100917140042.backup