Good point Bill I did unload all. I will do some testing by doing structure and data separately But again there where no PK and FK only normal indexes. Gunnar
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Bill Downall Sent: den 11 december 2002 21:12 To: [EMAIL PROTECTED] Subject: RE: Unload all/Reload/ Pack On Wed, 11 Dec 2002 20:43:05 +0100, Gunnar Ekblad wrote: >I know exactly what was lost in the process but can not understand why. >That makes me nervous even if I am confident that I have recovered >99.99999999% plus < % more Gunnar, Did you do one command, UNLOAD ALL, or did you split it into two commands, UNLOAD STRUCTURE and UNLOAD DATA? The second way, when you run the files to rebuild your database, the Primary Keys and Foreign Keys will be in place before the data attempts to load. If any tables were unloaded in the wrong order, none of the FK rows will load, because of not finding the matching PK row. Bill ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
