Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » SQL Anywhere database connections » Database file types » The transaction log

 

Changing the location of a transaction log (Sybase Central)

You can change the location of a transaction log using Sybase Central. For example, you may need to move the transaction log to a different drive on the same computer.

Prerequisites

The database cannot be running when you change the location of the transaction log.

Caution

The database file and the transaction log file must be located on the same physical computer as the database server or accessed via a SAN or iSCSI configuration. Database files and transaction log files located on a remote network directory can lead to poor performance, data corruption, and database server instability.

For more information, see [external link] http://www.sybase.com/detail?id=1034790.

For best results, the transaction log should be kept on a different disk from the database files. See The transaction log.

 Task

  1. In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.

  2. Click Tools » SQL Anywhere 16 » Change Log File Settings.

  3. Follow the instructions in the Change Log File Settings Wizard.

Results

The location of the transaction log is changed.

 See also
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0