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

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » The Database Server » The SQL Anywhere database server » Database options

Database options Next Page

-a database option


Applies the named transaction log. The -a database option must be specified after the database-file, and applies only to that database.

Syntax

{ dbsrv10 | dbeng10 } [ server-options ] database-file -a log-filename ...

Applies to

All operating systems and servers.

Remarks

This is used to recover from media failure on the database file. When this option is specified, the database server applies the log and then shuts down—it doesn't continue to run. If you need to apply multiple transaction logs, you must know the correct order in which to apply them when using -a. The database server automatically applies multiple transaction logs in the correct order if you use the -ad or -ar option instead of -a.

Specifying a cache size when starting the server can reduce recovery time.

See Backup and Data Recovery.

See also
Example

The following example, entered all on one line, applies the log file demo.log to a backup copy of the sample database.

dbeng10 "c:\backup\demo.db" -a "c:\backup\demo.log"