Subject Re: [firebird-support] Database corrupt - how to tell which index to rebuild
Author Thomas Steinmaurer
Hi Bob,

> 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"?


select rdb$index_name from rdb$indices where rdb$index_id = 4 and
rdb$relation_name = 'XRDS501'

Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions