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

Question: Why doesn't the Foxhound backup process create the generation2 subfolder?

Answer: Here's the short answer: Look for two identical scheduled tasks and delete one of them.

You should also rename the generation1 subfolder to generation2 because that's the name it should have.

The database backup subfolders are stored here on Windows XP:

C:\Documents and Settings\All Users\Application Data\RisingRoad\Foxhound2\backup
and on Vista and Windows 7 they are stored here:
C:\ProgramData\RisingRoad\Foxhound2\backup

Here is the long answer:

The Foxhound backup process

All Programs - Foxhound2 - Tools - Backup Foxhound Database
is supposed to save the most recent three generations of backup files in three subfolders: generation1 (the oldest), generation2 and generation3 (the latest), which are stored here on Windows XP:
C:\Documents and Settings\All Users\Application Data\RisingRoad\Foxhound2\backup
On Vista and Windows 7 the three subfolders are stored here:
C:\ProgramData\RisingRoad\Foxhound2\backup
If you accidentally schedule two backup tasks to run at the same time using the technique described in How do I backup my Foxhound database on a regular basis? there will be a conflict. Here is a description of the symptoms and one possible cause:

If the Foxhound backup generation2 subfolder is missing, but generation1 and generation3 are present, and the generation1 folder contains the second-most-recent backup (which normally would be stored in generation2), it is possible that two instances of the Foxhound backup process were started at the same time. If that is the case, the backup_log.txt diagnostic trace file in the generation3 subfolder will show the overlap: 

Thu 04/29/2010  1:00:00.33 ********************************* 
Thu 04/29/2010  1:00:00.33 *** Foxhound backup started 
Thu 04/29/2010  1:00:00.78 *** Starting dbeng11 if necessary... 
Thu 04/29/2010  1:00:00.78 ********************************* 
Thu 04/29/2010  1:00:00.78 *** Foxhound backup started 
Thu 04/29/2010  1:00:00.78 *** Starting dbeng11 if necessary... 
Thu 04/29/2010  1:00:02.11 *** Starting dbbackup... 
Thu 04/29/2010  1:00:02.14 *** Starting dbbackup... 
SQL Anywhere Backup Utility Version 11.0.1.2276
SQL Anywhere Backup Utility Version 11.0.1.2276
 (463407 of 462632 pages, 100% complete)
Transaction log truncated
Database backup completed
 (268235 of 267633 pages, 100% complete)
Transaction log truncated
Database backup completed
Thu 04/29/2010  1:06:22.96 *** Moving backup to the generation3 subfolder  
Thu 04/29/2010  1:06:23.13 *** Foxhound backup OK

The Task Scheduler accessory in Windows Vista and Windows 7 makes it quite easy to accidentally create two copies of the same scheduled task in two different task folders:

Delete one of the scheduled tasks to eliminate the conflict.

You should also rename the generation1 subfolder to generation2 because that's the name it should have:

See also...
How do I backup my Foxhound database on a regular basis?

This page was last updated on January 1, 2011. Foxhound 2.0 FAQ Home      Foxhound Home      RisingRoad      Breck.Carter@gmail.com