The database must not be running when you change the location of a transaction log.
For more information about how to choose the location of a transaction log, see Protecting against media failure on the database file.
To change the location of a transaction log (Sybase Central)
From the Tools menu, choose SQL Anywhere 11 » Change Log File Settings.
Follow the instructions in the Change Log File Settings Wizard.
To change the location of a transaction log mirror for an existing database (Command line)
Ensure that the database is not running.
Run the following command:
dblog -t new-transaction-log-file database-file
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|