>Looking for a suggestion.
>
>I have an vfp9 .exe with 8 tables (lots of children, all in 3rd normal form) linked with pk and fk's. All works fine (except for no way to secondary sort! makes me nuts). I need to build a menu option (File | Backup / Restore).

What is that about "no secondary sort"?

>The issue. How to design the data backup to be easily restored. I always recommend to my users to do a backup on a daily basis. To promote that process, the app needs to provide a simply click on the backup option, select a location and that's all the user needs to do.
>
>One day however, their hard drive is going to fail. Once repaired, they will be instructed to simply select the restore option and should quickly be back in business.
>
>The question. Is the backup process, simply copying the entire data folder (without manipulation) or is the backup a denormalizing process.
>
>The objective is to make the restore process as painless as the backup process.
>
>Any suggestions would be helpful (with an example?).

Just copying the entire folder should be OK.