Specifies that any transaction log files located in the same directory as the current transaction log should be applied to the database. The -ar database option must be specified after the database-file, and applies only to that database.

Syntax

{ dbsrv11 | dbeng11 }  [ server-options ] database-file -ar  ...

Applies to

All operating systems and database servers.

Remarks

When you include the -ar option, the database server looks for transaction log files associated with the database that are located in the same directory as the current transaction log. The transaction log location is obtained from the database. Transaction log files with starting log offsets greater than or equal to the start log offset stored in the database are applied, in log offset order. Once all the transaction log files have been applied, the database is stopped. You must also specify the -as option if you want the database to continue running once the transaction log files have been applied.

See also

• Recover from media failure on the data
• Recovering a database with multiple transaction logs
• -a database option
• -ad database option
• -as database option

Example

The database server applies the transaction log files (whose location is obtained from the database) to the mysample.db database. The database continues running after the transaction log files have been applied.

dbeng11 "c:\mysample.db" -ar -as