Restoring same database to multiple database instances on same dbserver

Posted in 1999

Dana Atteberry — Tue, 23 Nov 1999 11:35:38 -0600 — source: Informix-list mailing list archive (1991-1998)

We are currently using Informix Dynamic Server version 7.3 in our production environment. We want to be able to take a tape backup of the production database and lay it into multiple database instances on the same development database server. Our understanding is that because Informix takes the dataspace name; that the same database cannot be populated to multiple instances on the same dbserver from the same tape backup. Is there anyway to remove the dataspace name either in the backup or restore process to allow me to have the same database in multiple instances on one dbserver?

↪ replying to Dana Atteberry

Neil Truby — Tue, 23 Nov 1999 17:40:09 -0000 — source: Informix-list mailing list archive (1991-1998)

>Is there anyway to remove the dataspace name either in the backup or restore >process to allow me to have the same database in multiple instances on one >dbserver? No. It's an irritating feature of the software that you must restore to exactly the same chunk names. However, once you've got the first server in place you could use HPL or onunload/onload to make the copies.

↪ replying to Neil Truby

Dana Atteberry — Tue, 23 Nov 1999 14:40:12 -0600 — source: Informix-list mailing list archive (1991-1998)

What about ON-Bar? Will this tool provide the result I am looking for? "Neil Truby" <ntruby@netcomuk.co.uk> wrote in message news:81ejta$bkh$1@taliesin.netcom.net.uk... > > >Is there anyway to remove the dataspace name either in the backup or > restore > >process to allow me to have the same database in multiple instances on one > >dbserver? > > > No. It's an irritating feature of the software that you must restore to > exactly the same chunk names. > However, once you've got the first server in place you could use HPL or > onunload/onload to make the copies. > >