[AccessD] Backup routines

On Tue, 24 Feb 2004 07:18:38 -0500, Bobby Heid <bheid at appdevgrp.com> wrote:

> I think the answer is: it depends.
>
> If this is data that cannot be recreated easily and you have no other 
> backup
> mechanism in place, I'd say that this is not over-cautious.
>
> On my machine at home, I do weekly backups.  But I use a program called
> Replicator to replicate several key folders to another drive, just in 
> case.
>
> Bobby
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Carlos Alberto
> Alves
> Sent: Tuesday, February 24, 2004 7:00 AM
> To: AccessD List
> Subject: [AccessD] Backup routines
>
>
> Dear Members:
> I would like to have your input on this subject. I wrote a Sub to execute
> regular BE backups. Everyday thru a month a BE copy is compacted
> (DBEngine.CompactDatabase) and renamed and stored in a different folder.
> Do you think that such a 30-day backup routine is overzealous??? Thanks 
> for
> your opinion,

Hi Bobby!
It is a commercial medical app and hospital’s network administrator set 
just 5 backup copies (Mon thru Fri). Last year we faced a BE corruption 
and lost data because there was no backup copy older than 5 days.
:(
-- 
**************************************
* Carlos Alberto Alves               *
* Child Neurologist                  *
* Systems Analyst/Programmer         *
* Rio de Janeiro, Brazil             *
* mailto:caa at highway.com.br          *
**************************************