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 » Media failure recovery

 

Recovering from media failure on an unmirrored transaction log

Partially recover your database from media failure by using an unmirrored transaction log.

Prerequisites

There are no prerequisites for this task.

Context and remarks

If your database is a consolidated database in a MobiLink or SQL Remote installation, you should use a transaction log mirror or hardware equivalent.

Caution

The dbeng16 command should only be used when the database is not participating in a MobiLink or SQL Remote system. If your database is a consolidated database in a SQL Remote replication system, you may have to re-extract the remote databases.

 Task
  1. Make an extra backup copy of the database file. Without a transaction log, the database file contains the only record of the changes made since the last backup and the most recent checkpoint.

  2. Delete or rename the transaction log file.

  3. Restart the database with the -f option.

    dbeng16 "database-name.db" -f

    Without the -f option, the database server reports the lack of a transaction log as an error. With the -f option, the database server restores the database to the most recent checkpoint and then rolls back any transactions that were not committed at the time of the checkpoint. A new transaction log is then created.

Results

The database is partially recovered. Any transactions not committed at the time of the most recent checkpoint are rolled back.

 See also