Silly question about backups of live systems...

Posted in 2010

Ian Michael Gumby — Mon, 21 Jun 2010 22:19:08 +0000 — source: Usenet: comp.databases.informix

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. http://www.windowslive.com/campaign/thenewbusy?tile=multicalendar&ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_5

↪ replying to Ian Michael Gumby

Neil Truby — Tue, 22 Jun 2010 00:36:55 +0100 — source: Usenet: comp.databases.informix

----- Original Message ----- From: Ian Michael Gumby Newsgroups: comp.databases.informix To: informix-list@iiug.org Sent: Monday, June 21, 2010 11:19 PM Subject: Silly question about backups of live systems... >> 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? A restore from that archive will leave the database in its state at the time of the start of the archive.