Hello,

We have a database with around 2000 index on all the table. we have 40 tables with lot of rows (around 10 000 000 by tables) and lot of index in theses tables (around 40 index by table)

their is no way to change the structure of theses tables, all the index are present because we absolutely need them

now we have lot of the time database corruption (this is second time we have it in 2 week). for exemple today we receive :

Index 5 is corrupt on page 3872623 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1659
in table CONTACT (134)

and strange because at the same time we also have the similar error on other table :

Index 19 is corrupt on page 3154573 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1649
in table TRANSAC_SEARCH_VAC_A_2 (280)

Table contact don't have too much index (5) and TRANSAC_SEARCH_VAC_A_2 have lot of row and 30 index

So what can cause index corruption? what the good rules to folow to not have index corruption ?

thanks by advance
stephane