RE: Copying a database - suggestions please
You've got a lot more faith in hardware than I do...
Having experienced six or so RAID failures in the last year, three of which
required restores from backup, I know better.
ALWAYS do backups.
-----Original Message-----
From: Ye Chenwen [mailto:yechenwen@netnet.com.sg]
Sent: Wednesday, March 31, 1999 4:19 AM
To: informix-list@iiug.org
Subject: Re: Copying a database - suggestions please
Ever consider to buy a RAID storage system? You'll never need to do any
backup once you get one.
Neil Truby wrote in message <7ddli4$227$1@taliesin.netcom.net.uk>...
>IDS v7.24. UC6, HP-UX 10.20.
>
>I need to make a copy of a large dataabse (about 30GBytes) from one
database
>server to another but on the same UNIX server. There are the options I've
>considered:
>
>1. onunload/onload - a non-starter as a big in onload means that IDS
>tries to put detacted indexes back into their original dbspaces - but
>there's no equivalent option to put the tables back into original spaces.
>
>2. ontape back-up/restore - will only work if I do something smart-arse
>with chroot
>
>3. DBMS or hardware mirroring - not possible to make any use of this
once
>the links are broken.
>
>So I'm left with good old, slow old, dbexport/dbimport. Unless anyone has
a
>better idea????????
>
>thanks
>Neil
>
>