You can choose to maintain a transaction log mirror when you create a database. This option is available from the CREATE DATABASE statement, from Sybase Central, or from the dbinit utility.
Click Tools » SQL Anywhere 12 » Create Database.
Follow the instructions in the Create Database Wizard.
Use the CREATE DATABASE statement, with the TRANSACTION LOG and MIRROR clauses. For example:
CREATE DATABASE 'c:\\mydb.db' TRANSACTION LOG ON 'mydb.log' MIRROR 'd:\\mydb.mlg'; |
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 |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |