Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Remote » Managing SQL Remote systems


Recovering consolidated databases automatically

The following procedure describes how to automatically recover a consolidated database. To apply the transaction logs manually, see Recovering consolidated databases manually.

 Recover the database using the -ad option
  1. Make a copy of the database and transaction log file. This procedure assumes that previous backups of the database file have been made and are available, for example on tape.

  2. Restore the most recent backed up copy of the database (.db) file, not the transaction log file, from tape into a temporary directory.

  3. In the temporary directory:

    1. Start the database, applying the transaction logs using the -ad option.

      When you specify the -ad option, the database server looks in the specified directory for the transaction logs for the database. It then determines the correct order to apply the logs based on the transaction log offsets.

    2. Copy the current transaction log, to the temporary directory.

    3. Start the database and apply the current transaction log.

    4. Shut down the database server.

    5. Back up the database and transaction log.

  4. Copy database and transaction log files to the appropriate production directories.

  5. Restart your system as normal.

    Any new activity is appended to the current transaction log.

 See also