SQL Anywhere® Server - Database Administration  > 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 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.

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

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

---