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

Changing the location of a transaction log Next Page

Creating a database with a transaction log mirror


You can choose to maintain a transaction log mirror when you create a database. This option is available either from the CREATE DATABASE statement, from Sybase Central, or from the dbinit 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 create a database that uses a transaction log mirror (Sybase Central)
  1. In Sybase Central, choose Tools > SQL Anywhere 10 > Create Database.

  2. Follow the instructions in the wizard.

  3. To create a database that uses a transaction log mirror (SQL)
To create a database that uses a transaction log mirror (Command line)