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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » Database maintenance » Backup and data recovery » Database recovery » Database recovery with multiple transaction logs

 

Recovering a database with multiple transaction logs by using the -ad server option

Use the -ad server option to recover a database by applying all the transaction logs from a specified directory to the backup copy of a database.

Prérequis

There are no prerequisites for this task.

 Task
  1. Copy the backup transaction log and current transaction log into a directory.

  2. Start the database server and apply the transaction logs to a backup copy of a database:

    dbeng16 backup-copy-of-database -ad directory

    The database server uses the log offsets in the transaction logs to determine the correct order in which to apply the log files.

Résultat

The database server applies the transaction logs to the backup copy of the database and then shuts down.

Exemple

Start the database server and apply the transaction logs in directory c:\backuplogs to a backup copy of a database called backupdemo.db:

dbeng16 backupdemo.db -ad c:\backuplogs

 See also