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

SQL Anywhere 11.0.0 » SQL Anywhere Server - Database Administration » Maintaining Your Database » Backup and data recovery » Backup and recovery tasks

 

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 11 » Change Log File Settings.

  2. 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)

  1. Ensure that the database is not running.

  2. Run the following command:

    dblog -t new-transaction-log-file database-file

    See Transaction Log utility (dblog).