>Some have gone longer! There are reindexing utilities - mostley to remove the deletes, clean up the CDXs and do a physical sort on the primary key fields - or for repairs, when a system crash occurs.
>
>No - Luck has nothing to do with it - I practice - and have delivered a lot of mission critical, full cycle (full system) xBase projects. I take a lot of pride in my work and don't settle for half efforts. I am glad that less seasoned developers, that can excuse themselves for being a little sloppy, have clients (that probably really don't need SQL), willing to pay the cash so they don't have to pay attention.
>
>Its like buying a Sherman tank to take care of cockroach problem.

You must be lucky in that your customers listen to you and get the hardware, UPSs and backup systems required to minimize corruption risk. I am not so fortunate. Most of my customers are incredibly cheap and their network systems show it. No software can overcome a business that has an alleged "computer guy" who does their hardware.

My latest and greatest is the store where their "guy" found a bargain UPS that had 2 sets of outlets - one set surge only and the other set surge and battery. Guess which set he plugged his server and switch into? When the eventual power outage hit, his server immediately shut off in the middle of a business day and corrupted his database. The concurrent licenses part was also corrupted to the point where no one could connect to the server. The good news is, he saved his fax machine because he had that plugged into the battery and surge outlet. There last backup was 3 months old.