>>5) Use UPS for workstation power if the power is regularly unreliable (i.e. more than one brown-out or loss per year).
>
>I wonder what would happen if only the file server is protected by a UPS, and the workstation gets turned off. Do you think this would also cause corruption?

There's an excellent chance of causing INDEX corruption if that happens and updates/writes have been done and I SUSPECT that this is so even with FLUSH used.
I say this because I would NOT bet that a FLUSH on a table also results in a FLUSH on the CDX. It has always been in the back of my mind that this is *probably* the reason why we see more index "corruption" than we do (table) data "corruption".


>
>Another thing: I have seen several questions about index corruption lately - this might be an item for a FAQ.