Subject | Re: [firebird-support] lost of FK ...why? |
---|---|
Author | Alberto Pesce |
Post date | 2005-06-16T06:44:20Z |
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
Navighi a 4 MEGA e i primi 3 mesi sono GRATIS.
Scegli Libero Adsl Flat senza limiti su http://www.libero.it
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