Subject Re: [firebird-support] Identifying damanged pages
Author Josef KokeŇ°
Dne 29.3.2012 18:26, Ann Harrison napsal(a):
> 2012/3/29 Josef KokeŇ°<j.kokes@...>
>
>>
>> Due to hardware malfunction, my database got damaged. GFIX (-v -f -i)
>> tells me that a database has 1 "record level error", 9 "data page
>> errors", 41 "index page errors" and 322 "database page errors".
>>
>
> IBFirstAid is your friend, as is backup. But before you backup the
> database, make a copy, use gfix to set it to read only, and back it
> up with gbak, using the -g switch to suppress garbage collection.
>
> If that works, you're unlikely to have lost data. Backup walks each
> table in storage order. The structures are linked, so a lost or damaged
> data page will show up.

Luckily, the damaged table was one which rarely changes, so I was able
to restore it from backup with good results. But I am noting down this
suggestion for future reference. THanks for the suggestion!

Josef