Re: Logical consistency of archive

Dear Neil, Along with the archive of the data, Online also makes a copy of the logical logs which contain current/open transactions. It also takes the copy of the pages from the physical log into the backup tape. It uses this to rollback the transactions on restore. Regards, Dilip At 10:00 c 14/10/96 -0700, you wrote: }A restore of a non-logged database from an archive is in a state of }logical consistency isn't it? Yes, we all know that. } }But how does OnLine manage this. I can see how it's done if no }checkpoint is done between the start and end of the checkpoint. But if }one is done, with its attendant physical log emptying, how is consistency }maintained after restore? } }Thanks }Neil Truby }Chase Bank }Bournemouth } }