RE: Restoring individual databases

Posted in 1998

Simpson, Don — Thu, 5 Nov 1998 10:42:14 -0800 — source: Informix-list mailing list archive (1991-1998)

>> >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!