Re: Restore to test env

Dear Adam, Basically no. The restore must be done to the same chunk file names as was recorded with the archive. Because production and dev are on the same machine then in those instances the chunks must have different names. If dev was on a different box then maybe this could be done. Your best bet is to use onunload or dbexport, but both these require exclusive access to the production database. Assuming both dev and production are the same verison of online then I think onunload is the best method. HTH Jason On Wed, 05 Nov 1997 10:34:27 +1100, Adam Sorati <adams@sgen.com.au> wrote: >Eng: online 7.23.UC1 >OS: AIX 2.4.1 >HW: 1x166Mhz CPU, 128MG RAM and 2x4.5GIG disk. >DB: 1.3 GIG > 242 Tables > >I have a production instance and a development instance on the same >machine, the database in each is the same. A level 0 backup is done >each night for the production instance. > >A question has been put to me which I think is not possible however I >am getting great pressure to solve it. > >The question ' Is it possible to restore an old production backup to the > >development instance, without effecting the production instance at all. > >Any help would be appreciated >Thankyou > >Adam Sorati >adams@sgen.com.au > Jason Harris Informix DBA Westpac Banking Corporation NOTE: I add all these address at the bottom of people who spam me Now when their extractors extract my e-mail address they will also end up spamming each other. wtcjr@ix.netcom.com Shevsky@hotmail.com speech@speechrecognition.com SmartBiz@NevWest.com slender@juice4u.net sbliss@earthfriends.com ron@moneyaction.com removeme@gwh.net rocco@lostvegas.com market@DRAWBRIDGE.NET Foxyrusski@mail-response.com emaster@email-man.com waynesmail@earthlink.net root@localhost postmaster@localhost