Re: Silly question about backups of live systems...

Hi, Everything done before the archive checkpoint will be in the backup itself. Everything done after the archive checkpoint will be in logical logs - which you also should backup. Hence, you can freely choose the point-in-time (PIT) for the restore during restore time - it does not need to be decided/choosen at backup time. Obviously, the PIT should be at or after the archive checkpoint, but can't be before. Also obviously, the PIT should be before the time the last log that you backed up has filled. ON-Bar will then find and restore the necessary logs. Some info on the advanced level (you may skip this for now and read it at a later time): ;-) A) If you have several backups done with ON-Bar ... it will even find the correct backup to start the restore with, depending on the choosen PIT. :) B) There exists also the concept of transactions in IDS. If you have a transaction that is at the time of the choosen PIT, the actions done by this transaction will be rolled back at the end of the restore. This is to reach a point of logical consistency. Interestingly, this will also work correctly, if the transaction started before the archive checkpoint was done! C) Read more about PIT restore and backup/restore concepts in general in the appropriate manual: "Backup and Restore Guide". Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management IBM Deutschland Research & Development GmbH Chairman of the Supervisory Board: Martin Jetter Board of Management: Dirk Wittkopp Corporate Seat: Boeblingen, Germany Reg.-Gericht: Amtsgericht Stuttgart, HRB 243294 informix-list-bounces@iiug.org wrote on 06/22/2010 12:19:08 AM: > > Silly question. > > Suppose I have a large table and I'm backing it up for a point in time archive. > > The back up is done on a live system, so you have people inserting rows while the backup is running. > > Will those rows become part of the back up? > > An example... I start the back up at Midnight, and at 12:01, someone inserts a record. > What happens? > > Thx > > -G > > > The New Busy think 9 to 5 is a cute idea. Combine multiple calendars with Hotmail. Get busy._______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list