Al, and others, I have a 24/7 system here running with a VFP backup which periodically scans the tables in the database and then creates a new database and uploads the tables to it as required. The only thing it won't do is copy over stored procedures and RI conditions as I only use the DBC container to hold tables and do all the RI stuff programmatically.
The program works fine and if required I can put a stop on any database activity (update/insert/amend) whilst the backup is taking place but I do this from within the application itself. In addition the backup program also copies over the current version of the EXE associated with the data as well as the reports which are in a folder off the main data folder. This method means that in the case of a failure we can just copy over the dbc container and tables and immediately be up and running. The backup is currently scheduled to run every 60 minutes but this is changeable in the backup app. I can quite happily post up the code if required after a little bit of work Picture of running live program as of about 10 minutes ago whilst in mid backup at: www.replacement-software.co.uk/temp/Flexispec_Backup.png Dave Crozier -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen Sent: 07 February 2008 09:36 To: [email protected] Subject: RE: Backing up data from a running application Im interested in an answer. At the moment I open the tables and save as elsewhere for backup. Allen -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Newton I'm working on a project based on Visual Promatrix and I have run into problems trying to backup application and system data and what it boils down to is the fact that (e.g. using VFPCompression), open tables and databases cannot be backed up. And trying to close them before doing the backup and then re-opening them after the backup is a complete nightmare scenario ... So I need a tool (preferably free or cheap) that can backup open files - does anybody know if any of the above can do this (apart from VFPCompression, which I have already tested) ? Or another tool that can ? I've seen it mentioned elsewhere that DynaZip can do this - but I cannot get a definitive answer on this. Can anybody confirm ? No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.19.21/1263 - Release Date: 06/02/2008 20:14 [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
