iAnywhere.com - 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)

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.
  
  The Change Log File Settings wizard appears.
Follow the instructions in the wizard.

To change the location of a transaction log mirror for an existing database (Command line)

Ensure that the database is not running.
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.