Re: Restoring individual databases

Simpson, Don wrote: > > >> >What I'm really looking for is an Informix archiving utility that will > >> allow > >> >a DBA to restore a single database rather than the entire dbspace. > >> >Ontape can't do it. Onbar can't do it. I wish they did. > >> > >> There must be a way of restoring individual DB's and tables, surely! > > >Sure--put them in their own dbspaces. > > I've thought about that. But I have an instance with over 1400 databases in > it. I'm thinking maintenance on that many dbspaces would be a nightmare. > I'm not even sure Informix can handle that many. Anyone know? Not to > mention what onbar would do on level 0 backups, fork 1400 processes for each > dbspace? There might even be a system limitation there! Max 1024 dbspaces in a 2K page system (2048 on 4K page) also 1024 chunks (or 2048). Why 1400 databases? Couldn't that have been condensed into a relatively few databases? Anyway that's the answer. Art S. Kagel