Re: Magic? Or good design?

In article <35D9B5E8.5F27@netcomuk.co.uk>, ntruby@netcomuk.co.uk (Neil Truby) wrote: > Let's assume I'm backing up a large database server with a level 0 > archive, which will take 2 hours. I kick off the archive at 0400. The > pages that make up the instance are therefore being copied to the > archive tape at anything from 0 to 120 minutes after the start of the > archive. My users continue to update the server while the archive > progresses. The last pages are therefore copied some two hours after the > start of the archive, and may have undergone many updates in that time. > > If I then perform a restore, all pages in the database server will on > completion be in the state they were at 0400, even though they may not > actually have been copied to the tape for two hours after that. > > Briefly, how does the engine achieve this? > > Thanks > Logs??? Paul Watson # I don't suffer from WF Software Ltd. # stress, I'm just Tel. (+44) 1436 674729 # a carrier Fax. (+44) 1436 678693 #