ASA Database Administration Guide
  Backup and Data Recovery
    Backup and recovery tasks

Making a live backup

You carry out a live backup of the transaction log using the dbbackup utility with the -l option.

For more information about live backups, see Protecting against total machine failure.

To make a live backup

1. Set up a secondary machine from which you can run the database if the online machine fails. For example, ensure that you have Adaptive Server Anywhere installed on the secondary machine.

2. Periodically, carry out a full backup to the secondary machine.

3. Run a live backup of the transaction log to the secondary machine.

   dbbackup -l path\filename.log -c "connection_string"

You should normally run the dbbackup utility from the secondary machine.

If the primary machine becomes unusable, you can restart your database using the secondary machine. The database file and the transaction log hold the information needed to restart.