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.
The database cannot be running when you change the location of the transaction log.
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 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.
In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.
Click Tools » SQL Anywhere 16 » Change Log File Settings.
Follow the instructions in the Change Log File Settings Wizard.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|