SQL Anywhere® Server - Database Administration  > Backup and Data Recovery  > Backup and recovery tasks

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.

To create a database that uses a transaction log mirror (SQL)

• Use the CREATE DATABASE statement, with the TRANSACTION LOG and MIRROR clauses. For example:

  CREATE DATABASE 'c:\\mydb'
  TRANSACTION LOG ON mydb.log
  MIRROR 'd:\\mydb.mlg';

  See CREATE DATABASE statement.

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

• Use the dbinit utility with the -m option. For example, the following command (which should be entered on one line) initializes a database named company.db, with a transaction log kept on a different device and a mirror on a third device.

  dbinit -t d:\log-dir\company.log -m
  e:\mirr-dir\company.mlg c:\db-dir\company.db

  See Initialization utility (dbinit).

---