Re: Restore problem

Ren' Skree Jensen wrote: > Hi! > > We have a problem with our Informix Online Workgroup Server 7.22 (installed > on NT Server 4.0). > > We have dropped a table, and now want to use restore to get it back. But it > doesn't seem to work correctly. We don't get the table back using the > "space-restore" (not the whole system restore), and when we examine the > BAR_ACT.LOG file, it says that the physical restore is complete, but then it > has restored ALL the logical logs (and that includes the logical logs > created after the specific time and data we have chosen to restore to). > > What are we doing wrong??? > > Nothing. Unfortunately, onbar has a point-in-time restore capability, and a restore aparticular dbspace capability, but not both. The only way (assuming no other copies of the table, exports, etc) to get the table back is to point in time restore to just before you dropped the table. Of course, any other changes since then are lost, too. I've heard point-in-time for a particular dbspace is coming, but not quickly enough to help you. Sorry. Vic > > > Best regards > > Ren' Skree Jensen > rsj@geograf-as.dk -- Vic Goldberg Manager, DBA Team, Cornell University (607) 254-7441 (Voice) (607) 255-6982 (Fax)