Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - Database Administration » Starting and Connecting to Your Database » The database server » Database options

 

-ar database option

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
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