Gary Kjos
garykjos at hotmail.com
Tue Feb 24 13:32:10 CST 2004
You can't back up too much. Anytime a change is made to a database if disaster were to strike, that change could be lost. How big of a problem that would be to redo varies a lot by application. In most cases backing up a database every time an change is made is simply not feasible, so you find a balance between the pain of doing the backup verses the risk of having to redo the changes. Only you and the users of your database can really determine how frequent of a backup is necessary. If you have the disk space - and disk space is relatively cheap nowadays, once a day is pretty good insurance. Now a bigger question might be, how often are those 30 days of backups backed up? What do you do if the drive they are on fails? Or what if there is a fire in the building? Copying those backups off to a CD or a tape or a removable hard drive on a regular basis and taking those removable media to an offsite location or at least a fireproof safe would give you security against a different kind of disaster. Gary Kjos garykjos at hotmail.com _________________________________________________________________ Store more e-mails with MSN Hotmail Extra Storage – 4 plans to choose from! http://click.atdmt.com/AVE/go/onm00200362ave/direct/01/