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

The -a server option is used to recover a database by applying a single transaction log file to the backup copy of a database. When this option is specified, the database server applies the log and then shuts down. If you have multiple transaction logs, you must apply them one at a time in the correct order, from oldest to most recent.

Example

The following example applies the offline (backup) and current transaction logs to the backup copy of the sample database using the -a database server option.

Start the database server and apply a backup transaction log called backupdemo.log to the backup copy of a database called backupdemo.db:
dbeng12 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:
dbeng12 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 using the -a server option

Example

See also