> On Nov 5, 2015, at 2:18 AM, Peter Cushing <[email protected]> > wrote: > > We have a backup solution running every couple of hours that has a copy of > the database in another location and just appends the data to this, then > makes a date/timed copy of in another folder. If your system went down you > could copy this straight back and it would work fine. Instead of dumping the > data it is dragging the data.
I did that several years ago in a high-volume pharmacy application. We had nightly backups, but realized when we hit 1,000 orders / day that if the system went down in the afternoon we could restore the backup but iit would take a l-o-o-o-n-g time to re-enter today’s work. So I attached another workstation and just had it loop, comparing record counts in the dbf’s and appending from the server as required. Read only, no locks required. This was FPD 2.6, as I recall. Worked like a charm (perhaps an instance of Gall’s Law - successful because it was not ambitious?). Dan Covill _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.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.
