Re: Restoring individual databases

In article <71stft$ra$1@news.xmission.com>, Simpson, Don <don@alldata.com> writes > > >>> >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! ?? Why so many, surely you don't run 1400 systems on one machine. Sounds like you need to combine databases/rethink your design.. -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care