We have a process that must run in the morning after some other processes. People are in the application data by the time this last process runs. One of it's tasks is to copy all files from production to another directory. This has always worked before, but recently some of the copies of the tables have become corrupt. Usually when we restart the process, they copy fine.

Questions on two points:

Why can the files be copied if they are being used in the application? There must be issues with DBF, CDX and FPT files not being in sync, but we have done this for years with no issues. How has this ever worked?

What are the various causes for table corruption?