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

Use the -ad server option to recover a database by applying all the transaction logs from a specified directory to the backup copy of a database.

Prerequisites

There are no prerequisites for this task.

Copy the backup transaction log and current transaction log into a directory.
Start the database server and apply the transaction logs to a backup copy of a database:
dbeng16 backup-copy-of-database -ad directory
The database server uses the log offsets in the transaction logs to determine the correct order in which to apply the log files.

Results

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

Example

Start the database server and apply the transaction logs in directory c:\backuplogs to a backup copy of a database called backupdemo.db:

dbeng16 backupdemo.db -ad c:\backuplogs