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 foxhound3.log file to that folder. By default, foxhound3.log is installed in this location on Windows XP:

   C:\Documents and Settings\All Users\Application Data\RisingRoad\Foxhound3

   and on Vista and Windows 7 it is here:

   C:\ProgramData\RisingRoad\Foxhound3

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

   PAUSE Have you shut down the database?
   
   "%SQLANY16%\Bin32\dblog.exe" -t "G:\data\foxhound_log\foxhound3.log" "%FOXHOUND3%\foxhound3.db"
   
   PAUSE
   

5. Here's what the output looks like:

   C:\temp>PAUSE Have you shut down the database? Press any key to continue . . . C:\temp>"C:\Program Files\SQL Anywhere 16\Bin32\dblog.exe" -t "G:\data\foxhound_ log\foxhound3.log" "C:\ProgramData\RisingRoad\Foxhound3\\foxhound3.db" SQL Anywhere Transaction Log Utility Version 12.0.1.3356 "C:\ProgramData\RisingRoad\Foxhound3\\foxhound3.db" was using log file "foxhound 1.log" "C:\ProgramData\RisingRoad\Foxhound3\\foxhound3.db" is using no log mirror file "C:\ProgramData\RisingRoad\Foxhound3\\foxhound3.db" is now using log file "G:\da ta\foxhound_log\foxhound3.log" Transaction log starting offset is 0011371032 Transaction log current relative offset is 0474894106 C:\temp>PAUSE Press any key to continue . . .

6. Now you can start Foxhound again.