Recovering uncommitted operations (command line)

Use the dbtran utility to recovery uncommitted operations and reapply all committed transactions to the database.

Prérequis

There are no prerequisites for this task.

Contexte et remarques

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.

Note

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

Task

Run dbtran to convert the transaction log file into a SQL script file, using the -a option to include uncommitted transactions.
Edit the translated log (SQL script file) in a text editor and identify the instructions you need.

Résultat

The uncommitted operations are recovered.

Exemple

Run the following command to translate the log file sample.log into changes.sql file:

dbtran -a sample.log changes.sql

Recovering uncommitted operations (command line)

Note

Task

See also