Re: ?: Table Restore/Backup :?

In <1993May05.131535.949@sco.com> chrisw@sco.COM (Christopher J. Wood) writes: >Is it possible to perform table backups/restores with >Informix? No. 6.0 is reputed to have dbspace level backup support. >For example: if I'm running Informix OnLine and >multiple databases over multiple disks, would I have >to restore the entire database to recover from one (1) >disk going bad? It's worse than that. You would have to restore *ALL* the databases in the OnLine system, not just the one which contained the problem table. There is no concept of a database-level archive & log, let alone a table-level one. >Ideally I could simple restore the particular table that >was living on that disk. Since our database environment >is in the 20GB range, you can see the problem associated >with not being able to restore specific tables... A somewhat simplistic view. A table does not normally reside on only one disk. A disk does not normally contain only one table. Even if you design *your* system that way, there is no way for OnLine to know that you have done so. Even if it did, what would you rollforward from? >Any comments? This is why disk mirroring is provided. If you mirror your disks, it is extremely unlikely that you would lose both copies of any one disk at the same time, except as part of some much larger disaster. graeme -- Disclaimer: The author's opinions are his own, and not necessarily those of Pyramid Technology Ltd. or Pyramid Technology Inc. --------------------------------------------------------------------------- -m------- Graeme Sargent Voice: +44 (0)252 373035 ---mmm----- Senior Database Consultant Fax : +44 (0)252 373135 -----mmmmm--- Pyramid Technology Ltd. Telex: Tell who??? -------mmmmmmm- Farnborough, Hants GU14 7PL Email: graeme@uk.pyramid.com --------------------------------------------------------------------------- We have the technology. The tricky bit is learning how to use it.