Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere Server - Database Administration » Starting and connecting to your database » Database file types » The transaction log

 

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