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

Recovering from a live backup

A live backup is made to a separate machine from the primary machine that is running your production database. To restart a database from a live backup, you must have Adaptive Server Anywhere installed on the secondary machine.

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

To restart a database using a live backup

1. Start the database server on the secondary machine with the apply transaction log (-a) option to apply the transaction log and bring the database up to date:

   dbeng9 asademo.db -a filename.log

   The database server shuts down automatically once the transaction log is applied.

2. Start the database server in the normal way, allowing user access. Any new activity is appended to the current transaction log.