1) agree ( I use it when I am lazy and know I have backup) 2) agree ( My normal practise ) 3) agree ( even if I only practised it very little)
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 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Ben Petersen Sent: den 11 december 2002 11:53 To: [EMAIL PROTECTED] Subject: Re: Unload all/Reload/ Pack Gunnar, 1) Pack is risky also because there is no organic back up in the process. 2) Reload leaves the original so you can compare the two databases. Probably the best/easiest routine for regular maintenance. 3) Unload all followed by running the output file is the best routine for cleaning up problems with the database itself, and might be superior to #2 for maintenance. Someone on this list suggested: Sel (sum(sys_num_rows)) fro sys_tables from each database (old and new) in #2 and #3 above. Then you will know if there were any rows lost in the process. I do this each time. Ben Petersen On 11 Dec 2002, at 18:24, Gunnar Ekblad wrote: > Has someone a guidence? > 1. If I do a pack I understand I take a chance on no power breakdown. > 2. If I do a reload I should not have the risk of power breakdown but > have the same result as 1 obove. 3. If I do unload all then delete the > database base an load it back, that should be the same as 2 obove.!? > 4. If 2 and 3 and that does not give the same result what am I doing > wrong? 5. I am mostly on DOS 1.862 (or Windows corresponding version) > Background: 1. I am doing conversion work from Glorious 2.11 to Dos > version of today waiting for the future win 7.0 to go Windows when > happy days will arrive. Other minory ? that I can not answer! 1. Has > someone an Idea where I can look for answers? 2. Has anyone an Idea > what to look out four? Not to worry! 1. Some 20 % of my application is > running on 1.862 but I would be happy to understand above subject > before I Move remaining 80% from 2.11 > > ??? From the Swedish Dinosaur of 2.11 world ??? > Gunnar > > > > ================================================ > 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/ ================================================ 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/
