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

SQL Anywhere 12.0.0 » SQL Remote » Managing SQL Remote systems

 

Recover consolidated databases manually

The following procedure describes how to recover a consolidated database by applying each transaction log to the database. To have the SQL Anywhere database server automatically recover the consolidated database, see Recover consolidated databases automatically.

 To recover the database using the -a 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. Create a temporary directory.

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

    In the temporary directory:

    1. Start the backup copy of the database.

    2. Apply the old transaction logs using the -a option.

    3. Shut down the database.

    4. Start the database using the current transaction log and the -a option to apply the transactions and bring the database file up to date.

    5. Shut down the database.

    6. Back up the database.

  4. Copy the database to the production directory.

  5. Start the database.

    Any new activity is appended to the current transaction log.

 Example: Applying transaction logs individually
 See also