ASA Database Administration Guide
  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. Do one of the following:

   • If you are already connected to the database associated with the log file, select the Adaptive Server Anywhere plug-in in the left pane and then open the Utilities tab in the right pane. In the right pane, double-click Change Log File Settings.

   • If you are not connected to the database, click Tools > Adaptive Server Anywhere 9 > Change Log File Settings.

2. Follow the instructions in the wizard.

To start 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

   For more information about dblog options, see Transaction log utility options.