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.
Discuter à propos de cette page dans DocCommentXchange.
|Copyright © 2013, SAP AG ou société affiliée SAP - SAP Sybase SQL Anywhere 16.0|