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 » Backup and Data Recovery » Backup and recovery tasks

Creating a database with a transaction log mirror Next Page

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 10 > Change Log File Settings.

  2. Follow the instructions in the wizard.

    3. 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

      See Transaction Log utility (dblog).

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