I don't know the answer but I tested two of my databases (180 meg & 355 meg) and they unload without error. I created temp tables and tried the unload again and it ran error free. I don't think that temp tables are causing the problem.
I had a similar problem about a year ago and it ended up that it was a MS SE problem. The unload was being pathed via a mapped drive and sometimes the OS was reporting that the path was invalid. If you remapped the drive, everything worked fine. We got rid of SE and have not had the problem since. John -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Claudine Robbins Sent: Monday, February 14, 2005 11:26 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Unload failing I just TS'd to my db and tried disconnecting and reconnecting and the unload fails... Now what? > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of A. Razzak > Memon > Sent: Monday, February 14, 2005 8:01 PM > To: RBG7-L Mailing List > Subject: [RBG7-L] - Re: Unload failing > > > At 08:15 PM 2/14/2005, Claudine Robbins wrote: > > >Since I upgraded to 79 release this afternoon, I have > >been unable to back up my database. My backup file > >fails at the unload all command. RScope finds nothing > >wrong with the database. > > > >Anyone else experience this? > > Claudine, > > 01. Make sure that there are no TEMPORARY tables/views > defined prior to using the UNLOAD/RELOAD command. > > 02. Try the following test and see what you get: > > DISCONNECT > CONNECT dbname > SET NULL -0- > OUTPUT MyBackupDB.ALL > UNLOAD ALL > OUTPUT SCREEN > > 03. To automate the backup routine, you may also want > to take a look at the RBG7Backup.RMD file included > on your Fall 2004 Conference CD. > > If you need that file, let me know. > > Very Best R:egards, > > Razzak.
