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

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » Backup and Data Recovery » Backup and recovery tasks

Recovering from multiple transaction logs Next Page

Changing the location of a transaction log


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)
  1. From the Tools menu, choose SQL Anywhere 10 > Change Log File Settings.

  2. Follow the instructions in the wizard.

  3. To change the location of a transaction log mirror for an existing database (Command line)
    1. Ensure that the database is not running.

    2. Enter the following command at the command prompt:

      dblog -t new-log-file database-file

      See Transaction Log utility (dblog).