Starting a transaction log mirror for an existing database

Using the Transaction Log utility, you can choose to maintain a transaction log mirror for an existing database any time the database is not running. This option is available from either Sybase Central or the dblog utility.

For more information about why you may want to use a transaction log mirror, see Protecting against media failure on the transaction log.

To start a transaction log mirror for an existing database (Sybase Central)

  1. From the Tools menu, choose SQL Anywhere 11 » Change Log File Settings.

  2. Follow the instructions in the Change Log File Settings Wizard.

To start a transaction log mirror for an existing database (Command line)

  1. Ensure that the database is not running.

  2. Run the following command:

    dblog -m mirror-file database-file

    See Transaction Log utility (dblog).

You can also use the dblog utility and Sybase Central to stop a database from using a transaction log mirror.

Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0