|
Question: How do I keep the Foxhound log file from growing so large?
Answer: The easiest way is to regularly use the Foxhound2 - 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 dbsrv12 -m option in the following command files,
to tell SQL Anywhere to truncate the transaction log whenever a checkpoint is performed:
$backup_foxhound2.bat
$start_foxhound2_chrome.bat
$start_foxhound2_chrome_debug.bat
$start_foxhound2_engine.bat
$start_foxhound2_firefox.bat
$start_foxhound2_firefox_debug.bat
$start_foxhound2_ie.bat
$start_foxhound2_ie_debug.bat
By default, those command files are installed here on Windows XP:
C:\Documents and Settings\All Users\Application Data\RisingRoad\Foxhound2
and on Windows 7 they are here:
C:\ProgramData\RisingRoad\Foxhound2
See also...
Help - Introduction - Backup and Restore
Help - Introduction - Controlling Growth
How do the Foxhound backup shortcuts work?
How do I keep the Foxhound database file from growing so large?
|