Howdy,

Well yeah, you could restore the detail and it's master(s).  Then, assuming
that the production
database has been updated during the 13-14 hours, you can go deal with the
root file.  Also
assuming this is not a one_shot_deal you can ENSURE that the proper tapes
are being restored
at the proper time.  Now that we've got that out of the way, I'd like to
make you a bet.  My best
heifer against nothing that sooner or later something is going to go bump
and you will have a really
hosed (tech term) production database.  Partial restores are something to be
dealt with under
very controlled and specifc circumstances.

You don't say what kind of boxes you've got nor how many links into the
detail set.  If it's a
pretty simple setup you might try - 1) process on test box 2) extract the 8
million recs to a
plain jayne file 3) somewhere during #2 erase (Adager? DBgeneral? custom
prog) the production
dataset 4) load (Suprtool, custom prog?) the flat file to the production
data set.  Probably take
awhile on the load to production but it should significantly less than 13-14
hours, depending
on the box the database complexity.....blah, blah.

Now before you go thru all that, are you certain you have everything
optimized in the production
environment?

wel the users sing me their siren song - gotta run

Jim Trudeau


On Tuesday, December 15, 1998 11:42 AM, [log in to unmask]
[SMTP:[log in to unmask]] wrote:
> We have a test box and a production box.  We run processes on the test box
to
> offload them from the production box.  A particular process requires 13-14
> hours on the production box to populate an 8-million record TurboImage
> dataset.  The same job on the test box requires about the same amount of
> time. The benefit of running on the test box is that cpu processing time
is
> not being consumed on the production box.
>
> If one was to back up the datafile (Image master and detail files) on the
test
> box, is it safe to restore that file onto the production box?  I don't
know
> enough about how image databases and image root files work to say if this
will
> cause problems.
>
> Your input is greatly appreciated.  Thanks.
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own