27 Jan
2017
27 Jan
'17
7:22 p.m.
The thing is, with a database that is shared over many DBF files unless you can exclusively lock each one at a given point and then back them all up before unlocking you will never be sure you have a valid snapshot in time.
--
Alan Bourke
alanpbourke (at) fastmail (dot) fm
On Fri, 27 Jan 2017, at 06:54 PM,
mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
> On 2017-01-27 06:02, Man-wai Chang wrote:
> > Always wrote our own Foxpro routines to backup and/or do data transfer
> > (sometimes using external data compression programs) .... It's not
> > that complicated. :)
> >
> > On Fri, Jan 27, 2017 at 12:54 AM, Rick Schummer
> > profox@whitelightcomputing.com wrote:
> >> SET MARKETING ON && for those who are not interested
> >>
> >> CleverFox Backup backs up VFP data (DBC and/or free tables) even if
> >> they are open in shared mode, something other
> >> backups sometimes fail to do, or will only do when they table gets
> >> closed. It also can do SQL Server backups too, which
> >> is perfect for those who are using SQL Server Express, or better. All
> >> on a scheduled basis, configurable to be done
> > a call if you (or anyone else on the list) are interested.
> > 586.254.2530.
> >> ....
> >> SET MARKETING OFF
>
>
>
> Can't you just do a FLOCK() and then SELECT * from Source into table
> c:\backup\Target ?
>
[excessive quoting removed by server]