General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only