Re: Informix 5.x/7.x Backup

With OnLine 7.X, as in 5.X, all dbspaces can be saved to a single tape. The added functionality that 7.X gives you is that: a) You can specify that only certain dbspaces be saved to a tape b) You can specify that only certain dbspaces are restored from tape. In general, even in 5.X, it's a good idea to put databases in their own dbspaces, for performance reasons if nothing else. You should also avoid putting databases in the root dbspace. I like to have a dbspace for logical logs, the root dbspace (which also contains the physical log), and one dbspace (or more) for each database. You can use this model even if you really only have one physical disk -- just slice the disk or use offsets. Hope this helps, - Thomas J. Girsch Database Systems Manager Arch Communications Group, Inc. tgirsch@arch.com 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!