Foxhound 5.0 FAQ
search engine by freefind advanced
Foxhound 5.0 FAQ Home      Foxhound Home      RisingRoad           Breck.Carter@gmail.com     


Question: How do I move the Foxhound transaction log to a different physical disk drive?

Answer:

  1. Shut down Foxhound if it is running.

  2. Create a folder for the transaction log on a different physical drive; e.g., G:\data\foxhound_log

  3. Move the foxhound5.log file to that folder. By default, foxhound5.log is installed in this location on Windows 10:
    C:\ProgramData\RisingRoad\Foxhound5

  4. Run dblog.exe to modify the foxhound5.db file to point to the new location for the foxhound5.log file:

             "C:\Program Files\SQL Anywhere 16\Bin64\dblog.exe" -t "G:\data\foxhound_log\foxhound5.log" "C:\ProgramData\RisingRoad\Foxhound5\foxhound5.db"
             

  5. Here's what the output looks like:

    C:\temp>"C:\Program Files\C:\Program Files\SQL Anywhere 16\Bin64\dblog.exe" -t "G:\data\foxhound_log\foxhound5.log" "C:\ProgramData\RisingRoad\Foxhound5\foxhound5.db"
    SQL Anywhere Transaction Log Utility Version 17.0.9.4882
    "C:\ProgramData\RisingRoad\Foxhound5\foxhound5.db" was using log file "foxhound1.log"
    "C:\ProgramData\RisingRoad\Foxhound5\foxhound5.db" is using no log mirror file
    "C:\ProgramData\RisingRoad\Foxhound5\foxhound5.db" is now using log file "G:\data\foxhound_log\foxhound5.log"
    Transaction log starting offset is 0011371032
    Transaction log current relative offset is 0474894106
    

  6. Now you can start Foxhound again.

See also...
How do I move Foxhound to a different disk drive?
How do I move the Foxhound database to a different location?


This page was last updated on February 13, 2020.      Foxhound 5.0 FAQ Home      Foxhound Home      RisingRoad      Breck.Carter@gmail.com