SQL Anywhere® Server - Database Administration  > 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 10 > Change Log File Settings.

2. Follow the instructions in the 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. Enter the following command at the command prompt:

   dblog -t new-log-file database-file

   See Transaction Log utility (dblog).

---