Configuring Your Databases for Transaction Logs on Separate Drives

Use SQL Anywhere tools to configure and manage your consolidated databases for transaction logs and mirrored transaction logs on separate drives.

1. Shut down the SQL Anywhere server.
2. 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

3. Repeat this command for the clusterdb database:

   dblog -t D:\logs\clusterdb.log -m E:\logs\clusterdb.log clusterdb.db

4. Restart SQL Anywhere server to start using these logs on other disks.