Re: Refreshing data on a test database

All your chunk sizes must be identical in order to do a restore. And the new instance must have the same named (identical paths) pointers pointing to the same size (although not necessarily identically named) chunks. Cosmo Nigel Gall wrote: > At 08:01 PM 8/28/97 EDT, you wrote: > > > >Neil, Truby wrote: > >> > >> Our users have a requirement for a test database, with the data > regularly > >> refreshed from production. We achieve this by dbexporting the > production > >> database, dropping the test one then using dbimport to re-create > it. > >> > > > >If your physical layouts are the same, why not restore a production > backup > to the test > >system. That's how we do it. It's a LOT faster than > dbexport/dbimport. > > > > Is it possible to do this if the chunk names and numbers are the same > but > their sizes are different? Our production chunks are larger than our > test > environment, but both environments are sufficient in size to cover the > > present amount of production data. > > Another way of asking this is, what needs to be identical to both > environments for a restore of a level-0 archive of my production > system to > my test system to work? > > Thanks for you help. > > Best regards, > Nigel > +-------------------------------------------------------------+ > |Name : Edmund Nigel Gall Tel: (868) 636 3153 | > |Title : Information Systems Specialist Fax: (868) 679 3770 | > |Company: Process Plant Services Limited | > |Address: Atlantic Avenue, Point Lisas Industrial Estate | > | Point Lisas, Couva, Trinidad & Tobago, W.I. | > +----- mailto:nigelg@ppsl.com ------ http://www.ppsl.com -----+ -- * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ADDRESS ALTERED TO FOIL SPAMMERS: Remove "*NO-SPAM*" to reply. Cosmo Lee Multi-User Computer Systems Brooklyn, NY "JUST SAY 'NO' TO SPAM" * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *