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

Use the -a server option to apply a single transaction log file to the backup copy of a database, and then shut the database server down. If you have multiple transaction logs, apply them one at a time in the correct order, from oldest to most recent.

Prerequisites

There are no prerequisites for this task.

Task

Start the database server and apply a backup transaction log called backupdemo.log to the backup copy of a database called backupdemo.db:
dbeng16 backupdemo.db -a backupdemo.log
The database server applies the backup transaction log to the backup copy of the database and then shuts down.
Start the database server and apply the current transaction log called demo.log to the backup copy of the database:
dbeng16 backupdemo.db -a demo.log

Results

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

Example

Start the database server and apply a backup transaction log called backupdemo.log to the backup copy of a database called backupdemo.db:

dbeng16 backupdemo.db -a backupdemo.log

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

Start the database server and apply the current transaction log called demo.log to the backup copy of the database:

dbeng16 backupdemo.db -a demo.log

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

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

Task

See also