Multiple database copies
Posted in 2004
Topics: Backup & Restore, Versions, Editions & End-of-Life
It would be a valuable tool for me to be able to have two copies of my=
production database running on a test server.=20
=20
Is it possible to restore a database from IDS 9.4 onbar backup multiple=
times to the same server and rename them so that I have DBS1 and DBS2? If=
so, how is this done?
=20
Cheers
Gary March=20
Unix System Administrator=20
NIB Health Funds Limited
384 Hunter Street=20
Newcastle NSW 2300=20
PH. 02 4921 2466=20
Fax 02 4925 3548=20
Mobile 0418 412 390=20
E-mail: g.march@nib.com.au=20
=20
=
**************************************************************************=
***
The information transmitted in this message and attachments (if any) are=
intended only
for the person or entity to which it is addressed. The message may contain=
confidential
and/or privileged material. Any review, retransmission, dissemination or=
other use of,
or taking of any action in reliance upon this information, by persons or=
entities other
than the intended recipient is prohibited. If you have received this in=
error, please
contact the sender and delete this email and associated material from any=
computer,
The intended recipient of this email may only use, reproduce, disclose or=
distribute
the information contained in this email and any attached files, with the=
permission of
the sender.
=
**************************************************************************=
***
On Wed,
May 19, 2004 at 03:16:03AM -0400, Gary March wrote:
>
> It would be a valuable tool for me to be able to have two copies of my=
> production database running on a test server.=20
> =20
> Is it possible to restore a database from IDS 9.4 onbar backup multiple=
> times to the same server and rename them so that I have DBS1 and DBS2? If=
> so, how is this done?
> =20
<*nix>
$INFORMIXDIR/bin/dbaccess - <<EOS
RENAME DATABASE <old_database> TO <new_database>
EOS
</*nix>
HTH
--
Mark Thornber
=========================
E M Thornber CEng MIEE
Enchanted Systems Limited
Software Toolsmiths
+44 (0) 1503 272097