ASA Database Administration Guide
  Backup and Data Recovery
    Backup and recovery tasks

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 wish 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. Do one of the following:

   • If you are already connected to the database associated with the log mirror, in the left pane, select the Adaptive Server Anywhere plug-in, and then open the Utilities tab in the right pane. In the right pane, double-click Change Log File Settings.

   • If you are not connected to the database, click Tools > Adaptive Server Anywhere 9 > Change Log File Settings.

2. Follow the instructions in the wizard.

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

1. Ensure that the database is not running.

2. Enter the following command at the command prompt:

   dblog -m mirror-file database-file

   For more information about dblog options, see Transaction log utility options.

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