Fred

Basically, with this version of IDS, No !!
Get a second box, build it identically, install IDS and then restore.
You can then extract the data from this instance and insert into your
live database.
Of course, you already have the procedure for doing this as it is part
of your Disaster Recovery/Business Continuity strategy isn't it !

It isn't ? .... .. . . ....

Keith

-> -----Original Message-----
-> From: "Bob" < [mailto:no.reply@ace.iiug.org]
-> Sent: Wednesday, August 31, 2005 11:03 AM
-> To: informix-list@iiug.org
-> Subject: How to Restore a unique table from an ontape archive
->
->
-> Hi all,
->
-> I made an error and deleted some row in a table, restoring
-> all the database
-> from my ontape archive is not a valid solution and i must
-> find a way to
-> restore this only table. Is there any solution ?
->
-> My system is IDS 7.31 Workgroup edition running on Win 2000 (sp4)
->
-> Any help would be appreciated :-)
->
-> Fred
->
->

************************************************** ********************************
This message is sent in strict confidence for the addressee only. It may
contain legally privileged information. The contents are not to be disclosed
to anyone other than the addressee. Unauthorised recipients are requested
to preserve this confidentiality and to advise the sender immediately of any
error in transmission.
This footnote also confirms that this email message has been swept for the
presence of computer viruses, however we cannot guarantee that this message
is free from such problems.
************************************************** ********************************
sending to informix-list

Ok, not the solution i wanted :-) but i did it : took backup server from
storage room, copied backup files from main to backup then restored, unload
/ load and the table is there again :-)

Thanks for your answers

Fred

Ps : Going to planificate and unload every night just in case :-) its quite
boring to process giga of data for only few kb :-)



"Simmons, Keith" <keith.simmons@office2office.biz> a écrit dans le message
de news: 1125495674.70c14bcabfc1aa3c6aec10e76eb3337d@terane ws...
>
> Fred
>
> Basically, with this version of IDS, No !!
> Get a second box, build it identically, install IDS and then restore.
> You can then extract the data from this instance and insert into your
> live database.
> Of course, you already have the procedure for doing this as it is part
> of your Disaster Recovery/Business Continuity strategy isn't it !
>
> It isn't ? .... .. . . ....
>
> Keith
>
> -> -----Original Message-----
> -> From: "Bob" < [mailto:no.reply@ace.iiug.org]
> -> Sent: Wednesday, August 31, 2005 11:03 AM
> -> To: informix-list@iiug.org
> -> Subject: How to Restore a unique table from an ontape archive
> ->
> ->
> -> Hi all,
> ->
> -> I made an error and deleted some row in a table, restoring
> -> all the database
> -> from my ontape archive is not a valid solution and i must
> -> find a way to
> -> restore this only table. Is there any solution ?
> ->
> -> My system is IDS 7.31 Workgroup edition running on Win 2000 (sp4)
> ->
> -> Any help would be appreciated :-)
> ->
> -> Fred
> ->
> ->
>
> ************************************************** ********************************
> This message is sent in strict confidence for the addressee only. It may
> contain legally privileged information. The contents are not to be
> disclosed
> to anyone other than the addressee. Unauthorised recipients are requested
> to preserve this confidentiality and to advise the sender immediately of
> any
> error in transmission.
> This footnote also confirms that this email message has been swept for the
> presence of computer viruses, however we cannot guarantee that this
> message
> is free from such problems.
> ************************************************** ********************************
> sending to informix-list