RE: seeking for advise about backup-and-restore

Posted in 2003

Malcolm Garbett — Wed, 1 Oct 2003 08:15:45 +0100 — source: Usenet: comp.databases.informix

Ken, With 30 + users and a "live" database of around 400 MB - 2.5 million rows and no night-shift nor weekend working we do... Level 1 at mid-day. } }Monday - Friday Level 0 at 5.00 PM } We don't backup logs. (Incidentally, I take both tapes off-site with me.) Note - this is what we actually do. It is not advice as your site might be very different. Regards, Malcolm Garbett -----Original Message----- From: Ken Hu [mailto:kenhu1970@yahoo.com.tw] Sent: 01 October 2003 02:46 To: informix-list@iiug.org Subject: seeking for advise about backup-and-restore Dear All: This what I consider as our backup/restore scenario: (1)Level 0 -> at the eginnging of every month (2)Level 1 -> at the beginning of every week (3)Level 2 -> everyday excepts the days we make level 0 or level 1 backup. My question is : when should I make the logical log backup ? After the level 2 backup ? Please share your valuable experience or suggestion with me , really apprecaite it . Ken sending to informix-list sending to informix-list