Re: Is table or database level backup possible?

> Hi. We are running 7.20 on HP-UX 10.01. I am new to Informix and have > a > question about backup/restore. It appears that I can use ontape to > backup > the instance, but I must restore the whole instance to get a single > database or table back. I was thinking about doing an ontape and also > dbexporting all of the databases and letting them get backed up with the > regular file system backups. You are correct. The concept of OnLine archiving is to back-up and restore the whole online system. It never was, nor ever could be used for table or database back up purposes. I come from the old school who believe that prior to installing any new component that you should take a backup of any data that could get corrupted. I always do that using dbexport and dbimport for restoration. You should also be aware that if you ever want to reconfigure your OnLine system, or move between hardware platforms or Operating systems(possibly including versions) you should do a dbexport of the data as online archiving/restore will not always work over changes of this nature. > > How do others backup/configure their instances to allow the restoration > of > single tables or databases? Is there 3rd party software that will help > with this? > > Thanks for the help. > > Craig > ctreptow@aol.com > > > > Craig Treptow > ctreptow@aol.com Malcolm Weallans Online Database Consultancy Phone 01628-72154 Fax 01628-37463 CIX - onlinedbc