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

 

Recovering uncommitted operations (Sybase Central)

Use Sybase Central to recover uncommitted operations and reapply all committed transactions to the database.

Prerequisites

There are no prerequisites for this task.

Context and remarks

In some circumstances, you may want to find information about transactions that were incomplete at the time of the failure. When recovering from media failure on the database file, the transaction log must be intact.

The Translate Log File Wizard helps you translate a log file into a .sql file from Sybase Central.

Note

The transaction log may or may not contain changes right up to the point where a failure occurred. It does contain any changes made before the end of the most recently committed transaction that made changes to the database.

 Task

  1. In Sybase Central, click Tools » SQL Anywhere 16 » Translate Log File.

  2. Follow the instructions in the wizard.

  3. Edit the translated log (SQL script file) in a text editor and identify the instructions you need.

Results

The uncommitted operations are recovered.

 See also
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0