Specifies that any log files located in the same directory as the 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 log files associated with the database that are located in the same directory as the transaction log. The transaction log location is obtained from the database. 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 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 log files have been applied.

See also

• Recovering from media failure on the database file
• Recovering from 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 log files have been applied.

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