ASA Database Administration Guide
Backup and Data Recovery
Backup and recovery tasks
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 wish 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)
Do one of the following:
If you are connected to a database, 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 Create Database.
If you are not connected to a database, click Tools
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 clause.
For more information, see CREATE DATABASE statement.
To create a database that uses a transaction log mirror (Command line)
Use the dbinit command 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
For more information about initialization options, see Initialization utility options.