Foxhound 1.1 FAQ      Foxhound Home      RisingRoad      Breck.Carter@gmail.com


Question: How do I keep the Foxhound log file from growing so large?

Answer: The easiest way is to regularly use the Foxhound1 - Tools - Backup Foxhound Database shortcut which will backup and restart the active Foxhound transaction log file, keeping only the three most recent backups and discarding older copies.

You can automate the backup task; see How do I backup my Foxhound database on a regular basis?

Another way to limit the transaction log size is to specify the dbsrv11 -m option in the following command files, to tell SQL Anywhere to truncate the transaction log whenever a checkpoint is performed:

$start_foxhound1_engine.bat
$start_foxhound1_firefox.bat
$start_foxhound1_firefox_debug.bat
$start_foxhound1_ie.bat
$start_foxhound1_ie_debug.bat

By default, those command files are installed here on Windows XP:

C:\Documents and Settings\All Users\Application Data\RisingRoad\Foxhound1
and on Windows 7 they are here:
C:\ProgramData\RisingRoad\Foxhound1

See also...
Foxhound Help - Controlling Growth
Foxhound Help - Backup and Restore
How do I keep the Foxhound database file from growing so large?


This page was last updated on February 4, 2011.      Foxhound 1.1 FAQ      Foxhound Home      RisingRoad      Breck.Carter@gmail.com