Re: Restore a specific table or database...HOW?
What companies do make 3rd party archival products for Informix? Do
anyone have a name/number/e-mail address for any of them? Any reply
will be greatly appreciated.
Thanx
=====================================================================
Paul Watje Database Something or Another
watjep@hasting.com Hastings Books, Music, & Video
----------
}David Clough (dclough@teleport.com) wrote:
}: I am using Informix Online ver. 5.x on a Sun SparcStation.
}: The data is stored in a raw device and Informix
}: takes care of the behind-the-scenes stuff. I am using
}: tbtape -s and tbtape -a to backup the database and logical
}: log files.
}
}: How can I restore a specific table or database?
}
}No chance, unless you've used tbunload to unload a specific table or
database.
}Dbexport will do it at the database level.
}
}One of the things I've been screaming about forever is the lack of a
logical
}level archive product. We are finally looking at 3rd parties like DGC
}(they make Intelligencia) and OpenVision (OpenV Archive).
}
}If Informix would trash dbexport and tbunload, and make ONE really good
}(and fast) product that will support real archiving with archives that
}are compatible across releases, then they'd be doing all of us a favor.
}
}tbtape and onarchive are not real archiving products. They are disaster
}recovery **backup** products. A real archiving product would let you
}restore databases or tables going back to any time period, any release.
}
}M. Reed, HCIA, Ann Arbor, MI mreed@hcia.com