Subject Re: [firebird-support] Database recovery options...- how to develop 100% reliable DB solution?
Author Ann W. Harrison
vincent_kwinsey wrote:
> So - this is rather rare case when fdb file gets corrupted (there
> are error messages like 'wrong page number...', 'gds consistency
> check...' and so on) but - anyway - when this occurs then - up to my
> knowledge - there is not straighforward and realiable way for data
> recovery. 'gfix -mend' cann't always remove all the errors.


I'd suggest replication to a second server. Replication is done at
a logical level - as opposed to shadowing which is physical and will
cause corruption to appear in both the main database and shadow.
With replication, there is no recovery process. Just switch to the
second copy, set up a third copy, and you're running again.


Regards,


Ann