Changing the location of a transaction log

 Change the location of a transaction log (Sybase Central)

The database cannot be running when you change the location of the transaction log.

For information about how to choose the location of a transaction log, see The transaction log.

  1. Use the SQL Anywhere 12 plug-in to connect to the database.

  2. Click Tools » SQL Anywhere 12 » Change Log File Settings.

  3. Follow the instructions in the Change Log File Settings Wizard.

 Change the location of a transaction log mirror for an existing database (command line)

The database cannot be running when you change the location of the transaction log.

  1. Ensure that the database is not running.

  2. Run the following command:

    dblog -t new-transaction-log-file database-file
 See also
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1