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

AFAIR.

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
http://www.upscene.com