Subject Re: [firebird-support] lost of FK ...why?
Author Alberto Pesce
Thanks for support!

In fact the problem never presented on other server.
So I try to monitor the status of Server's Power.

Do you think it's possible resolve this problem without change the server?

Alberto

>
> Alberto,
>
>
> Alberto Pesce schrieb:
>
> > Well, when I find this situations I do:
> >
> > 1. Backup my db in a file .gdk but this don't finish correctly
>
> How do you do this backup, which options do you use?
>
> The source of the problem can't be the lost parents at this point since
> backup doesn't care about them, you will notice when trying to restore
> the database from this backup.
>
> The only time I had a problem like this was back in times of IB5.6 when
> there were problems with the server and power failures while
> ForcedWrites was off.
>
> > 2. So I Extract Metadata with schema and data in a file (very big file .sql)
> > 3. I try to Execute this and I obtain the line which cause violation of FK
> > 4. I correct with a editor of text
>
> As soon as you can backup the database but aren't able to restore it you
> can delete these orphaned records by sql - which won't solve your
> problems but it still seems to better than editing in a sql file...
>
>
> Luc.
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>



____________________________________________________________
Navighi a 4 MEGA e i primi 3 mesi sono GRATIS.
Scegli Libero Adsl Flat senza limiti su http://www.libero.it