The database cannot be running when you change the location of the transaction log.
For more information about how to choose the location of a transaction log, see The transaction log.
To change the location of a transaction log (Sybase Central)Use the SQL Anywhere 12 plug-in to connect to the database.
From the Tools menu, choose SQL Anywhere 12 » 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 |
See also |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |