Re: restore informix table

If you use on-bar with any storage manager, you can do point in time recovery or to a specific log no. Both work well. I did it multiple times with Alexandria on IDS 7.30/731.UC2. Sanjeev K. Sagar --- June Tong <june_t@hotmail.com> wrote: > trieu@ti.L-3Com.com wrote: > > > Hi all, > > Can some body please show me step by step > how to restore the table > > acident been deleted it. Thank you in advanced. > > If you use ontape/tbtape to do your backups, then > surf on over to the IIUG > Software Archives at > http://www.iiug.org/software/special_software/special_software_top.html > and > get Arcunload. > > If you don't use ontape/tbtape, then I don't think I > can help you. > > June > -- > june_t@hotmail.com > Back in Palo Alto, living on Kit Kat bars and > chocolate chip cookies > > Please do not send Informix questions to this > account. > I would add 'Please do not send spam to this > account' > but I suppose I would be wasting my bits. > > > _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com

Ah, perhaps I should have been more specific. I was assuming that if a table had been deleted accidentally and he wanted to restore it, it would *not* be okay to simply restore to a point-in-time before the table was dropped, because then any changes to the rest of the instance since the deletion would be lost; that is, it is not possible to restore only one table to a point-in-time: the entire instance must be recovered to the same point-in-time. Of course, I could be wrong about this (about the part where he didn't want to restore the whole instance back to the point in time, I mean -- I'm quite sure I'm right about the rest). Could just be me: if you have a hammer, everything looks like a nail. June sanjeev sagar wrote: > If you use on-bar with any storage manager, you can do point in time > recovery or to a specific log no. Both work well. I did it multiple > times with Alexandria on IDS 7.30/731.UC2. > > Sanjeev K. Sagar > --- June Tong <june_t@hotmail.com> wrote: > > trieu@ti.L-3Com.com wrote: > > > > > Hi all, > > > Can some body please show me step by step > > how to restore the table > > > acident been deleted it. Thank you in advanced. > > > > If you use ontape/tbtape to do your backups, then > > surf on over to the IIUG > > Software Archives at > > > http://www.iiug.org/software/special_software/special_software_top.html > > and > > get Arcunload. > > > > If you don't use ontape/tbtape, then I don't think I > > can help you. -- june_t@hotmail.com Back in Palo Alto, living on Haagen-Daz ice cream bars Please do not send Informix questions to this account. I would add 'Please do not send spam to this account' but I suppose I would be wasting my bits.