Use SQL Anywhere tools to configure and manage your consolidated databases for transaction logs and mirrored transaction logs on separate drives.
These tools are located in the <SUP_HOME>\Servers\UnwiredServer\SQLAnywhere11\BIN32 directory. Add this directory to your PATH.
-
Shut down the SQL Anywhere server.
-
From the SQLAnywhere11 directory, run:
dblog -t D:\logs\uaml.log -m E:\logs\uaml.log uaml.db
Output from a successful run of this command will look similar to:
SQL Anywhere Transaction Log Utility Version 11.0.1.2250
"uaml.db" was using log file "uaml.log"
"uaml.db" was using no log mirror file
"uaml.db" is now using log file "D:\logs\uaml.log"
"uaml.db" is now using log mirror file "E:\logs\uaml.log"
Transaction log starting offset is 0000746294
Transaction log current relative offset is 0001015441
-
Repeat this command for the clusterdb database:
dblog -t D:\logs\clusterdb.log -m E:\logs\clusterdb.log clusterdb.db
-
Restart SQL Anywhere server to start using these logs on other disks.