AuditMaster

Re: Backup of AuditMaster data files

glynn — Sat, 01 Aug 2009 10:43:39 GMT

Thanks Jay. I am going to use BtrieveBills solution in this instance as I have a user running a Crystal report using direct SQL queries, and I only want to archive and compress once a month. Co-incidentally though, your suggestion solved another problem I was wondering about.

Re: Backup of AuditMaster data files

BtrieveBill — Wed, 29 Jul 2009 15:50:56 GMT

You can use the Continuous Operations Mode -- a feature of the database system since the Btrieve 6 days. For an explanation of how this works and how to do it, check out the white paper on proper backups here:

http://www.goldstarsoftware.com/press.asp

Re: Backup of AuditMaster data files

Jay.Clark — Wed, 29 Jul 2009 14:53:01 GMT

Are you using a backup software? I would say backup the directory where the archives are. You could always restore the directory from the backup if there is an issue with the files. Remember, moving an archived file out of its folder (i.e., \Arch or \Comp in the installation directory) grays out its entry in the data tree. Moving it back restores the entry and enables queries again. Permanently deleted files cannot be restored.

Backup of AuditMaster data files

glynn — Wed, 29 Jul 2009 12:13:31 GMT

What is the correct way to back-up the data that AuditMaster is currently saving. I assume one possibility is to archive the data and then copy the archive file to a backup location, but this would not be feasible every night. Any ideas would be appreciated.

Regards

Glynn

glynn@snowyriver.co.za