| Subject | Database corrupt - how to tell which index to rebuild |
|---|---|
| Author | Bob Murdoch |
| Post date | 2006-07-17T14:30:37Z |
I just experienced my semi-yearly database corruption on an FB 1.5
30GB database running on W2K3 server. I just finished running gfix,
and have a number of entries in Firebird.log that look like this:
Index 4 is corrupt on page 3853736 in table XRDS501 (303)
From previous experience, I know that I can alter the index
inactive/active to rebuild it. However, how do I know exactly which
index is "Index 4"?
tia,
Bob M..
30GB database running on W2K3 server. I just finished running gfix,
and have a number of entries in Firebird.log that look like this:
Index 4 is corrupt on page 3853736 in table XRDS501 (303)
From previous experience, I know that I can alter the index
inactive/active to rebuild it. However, how do I know exactly which
index is "Index 4"?
tia,
Bob M..