[firebird-support] How to locate and delete records connected to a bad sectors ?

2012-11-01 Thread stephane
Hello, On our database (FB 2.5) of 150 GB we have 21 bad sectors of 512 bytes (all in the same block). because of that the backup/restore not work (even with the -ignore option). And gfix not help us too much because it's freeze and crash the fb_inet_server (but it's was also the case before

Re: [firebird-support] How to locate and delete records connected to a bad sectors ?

2012-11-01 Thread Alexey Kovyazin
Hello Stephane, I assume that your database has good non-corrupted metadata, so you just need to buy FBDataGuard and export all available records from tables with problems (using re-export of metadata), then merge good data from corrupted database and exported records into new healthy

Re: [firebird-support] How to locate and delete records connected to a bad sectors ?

2012-11-01 Thread Ann Harrison
Stephane, Starting with your subject, you can't delete records in bad sectors. You can drop tables that have data pages in bad sectors because those pages aren't touched when the table is dropped. When dropping a table, Firebird reads the RDB$PAGES table to find the pointer pages and index