Re: Informix 5.x/7.x Backup

ON-BAR is extremely flexible. Use can specify whatever backup strategy makes sense for your situation. You may group DBSpaces in save-sets or back them up individually. One caveat; you will need to get a 3rd party backup program to manage this. We use Legato, but I understand that Alexandria's B/U works as well. You other alternative is to use dbexport to dump the database to disk and let your Unix B/U software handle it. This requires exclusive access to the DB during the export (of course), and so you will need to make the DB unavailable during the process. -d Tony Marasco wrote in message <34A0291E.E7CFF2A2@berksiu.k12.pa.us>... >We are considering many backup strategies and I was >wondering if anyone has similar needs. > >We are running Online 5.x presently with many unique databases. >Using "tbtape" saves all spaces and databases and I was told >it restores all spaces and databases. This is not satisfactory >as it is possible for one database to need a restore while the >others do not. > >We were told that Online 7.x allows single spaces to be saved >and restored. It was suggested that each database be placed >into its own space. A restore to a space is equivalent to >a single database restore. > >I am guessing that Online 7.x saves a space to a tape. That >is, I cannot save two or more different spaces to the same >tape. Therefore, using the above scenario forces me to >store 3 databases/spaces on 3 tapes. We will have at least >25 of these unique databases so that could mean 25 tapes! >