Hi Tom

I think your points on preventing database corruption is quite on the mark. Of course they apply to any database that one uses and are simply common sense. And I also agree with you iro using DBF and DBC. I find they work for the type of appplications I develop.

I find that topics like these are more often about using "what I know" rather than using the "best solution". To a hammer everything is a nail? (To managers everything needs to be nailed and to employees - well, we are the nails :)

On top of which "best solution" is also often a difficult point to quantify. And how many of us actually have the knowledge and experience of both sides of the coin to be able to judge. I know I dont. Too often subjective preferences are presented as objective proofs.

And one crucial aspect is almost always overlooked. All the "best technology" in the world won't make up for a bad implementation. (Which is why there's so little hope for me!) To ruin a phrase - I would rather have an average technology solution implemented well than the best technology solution implemented by me poorly.

Go Well.



>>>
>>>1. Have a clean and stable source of primary power.
>>>
>>>2. UPS supplies in case of power loss.
>>>
>>>3. Be aware that computer power supplies that are 3 years or older may become a source of data corruption due to deterioration of components, which can place voltage spikes on the output filtered voltage.
>>>
>>>4. Good cables, and Hubs (switchers, etc.).
>>>
>>>5. Define which operating systems and service packs are being used by each computer and be aware if there are any concerns about how they handle data.
>>>
>>>6. For Novel use the latest patches and seek out answers before there are problems. Determine if the version or versions of Novel you use have known problems by asking others in the community.
>>>
>>>7. Peer to peer is a touchy topic, which can work well with two or three computers.
>>>
>>>8. Use of a product such as Stonefield Database toolkit to repair damaged tables or indexes without user intervention.
>>>
>>>9. It is important to have a good data backup strategy and be sure that it works! On one occasion my back up media was defective and luckily it was not needed. That is an experience I will never forget. When you buy the best tape and expect it to work and does not it is your problem.
>>>
>>>These are some of the things I would consider. There are many versions of Novel and each one has had some “interesting and unique” behavior while performing such things as handling data or printing.
>>>
>>>Tom
>>>