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.
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.
Notes:
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
Still have questions? We can help. Submit a case to Technical Support.