"I always run gfix -mend before gbak..."

Sorry, I always run it when we have Stuck in Limbo, index corruption, etc...
But sometimes broken a FK and recreate it solve the problem...
I will change our routine NOW!!!


Follow how it works until yesterday:


gfix -v -full 127.0.0.1:"C:\Arquivos de programas\Firebird\Firebird_2_0\bin\copia.fb"

gfix -mend -full -ignore 127.0.0.1:"C:\Arquivos de programas\Firebird\Firebird_2_0\bin\copia.fb"

gfix -mend -ig 127.0.0.1:"C:\Arquivos de programas\Firebird\Firebird_2_0\bin\copia.fb"
pause

gbak -b -g -v -ignore -limbo 127.0.0.1:"C:\Arquivos de programas\Firebird\Firebird_2_0\bin\copia.fb" copia.fbk

pause

del banco.fb

gbak -create -v -P 8192 copia.fbk banco.fb



Thank you very much,

Rodrigo Ap. Cardoso
PS: Sorry my bad english...




Em 02/03/2010 17:38, Helen Borrie escreveu:

> At 06:28 AM 3/03/2010, you wrote:
>
>> "The mend option on gfix can be dangerous - it can lose data - sometimes
>> lots of data. Use it *only* if you've got a corruption that prevents a
>> backup and restore and when losing some data is preferable to losing
>> everything. "
>> written by Paul Beach in September 2000 at:
>> http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_db_corr/
>>
>> I always run gfix -mend before gbak...
>>
>> /I would like to know if it can be dangerous at firebird 2.0.X ?
>>
> Yes. Don't do this! -mend has no place in your regular backup routine.
>
> Its purpose is to disable bad structures that have been flagged by a preceding validation, i.e., -mend is a tool that is used in association with other tools during a recovery attempt, to clean up. Once the final step of this procedure is done (a final gbak -b), anything that gfix -mend has done is gone without trace.
>
> But I'm curious as to why you thought you had to do it.
>
> ./heLen