Re: parallel backup and restore w onbar

I think you mean : "can I do parallel backup and restore on an instance that has ONLY databases WITHOUT transaction logging?" As long as you backup the logical logs yes you can, but maybe you shouldn't: If your databases spawn more than 1 dbspace, and there are tables related among the dbspaces, then the data will be logically corrupted, take this example: - Instance with a single non-logging database named "mydb", created in rootdbs. - "mydb" has 2 tables : + "parent" + "child" - You have a foreign key from child to parent. - Each table is a different dbspace A parallel backup/restore will work, however the tables will probably be out of syncs (You oculd get parents without children or children without parent). This is becasue a parallel backup is in reality a dbspace backup. YOu can only take snapshots of the dbspaces. Without logs there is no way to "glue" this backups to see the "whole picture" Gustavo Floyd Wellershaus wrote: > hello, > In IDS10, using onbar, can I do parallel backup and restore on an > instance that has no database transaction logging ? > I think I should be able to, as long as I backup the logical logs and > logs will need to be restored during a parallel restore. Is that correct ? > > ps. I realize I won't be getting schema changes that occurred since > the last archive, but that's ok for now. > > Thanks, > Floyd > > > ------------------------------------------------------------------------ > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >