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

Syntax

{ dbsrv11 | dbeng11 } [ server-options ] database-file -a log-filename ...

Applies to

All operating systems and database servers.

Remarks

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

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

Example

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

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