The -ad server option is used to recover a database by applying all the transaction logs from a specified directory to the backup copy of a database. When this option is specified, the database server applies the transaction logs and then shuts down the database.
Start the database server using -ad to apply the transaction logs to the backup copy of your database. See -ad database option.
The following example applies the offline (backup) and current transaction logs to the backup copy of the sample database using the -ad database server option. The database server uses the log offsets in the transaction logs to determine the correct order in which to apply the log files.
Copy the backup transaction log and current transaction log into a directory, for example, c:\backuplogs.
Start the database server and apply the transaction logs to a backup copy of a database called backupdemo.db:
dbeng11 backupdemo.db -ad c:\backuplogs |
The database server applies the transaction logs to the backup copy of the database and then shuts down.
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |