I have a client who has now lost their transaction history file for the 2nd time. By that I mean, all records between 23rd of March and sometime in August 2016
I've checked the file. The records are not there with a deleted flag. They're gone, as if deleted and packed.
It's most bizarre, and of course, my system gets the blame.
About the only thing I've noticed with their system is they run iCloud on their Windows 10 pc. It pops up about every 15 secs in the right hand system tray, to say it has synchronised some files.
My system has maybe 75 free standing dbf/fpt/cdx files. The corrupted history file only has about 10,000 records, where, on 2 occasions, 120 records have disappeared.
Does anyone wish to comment.
I don't know anything about ICloud but I found this link which may help. http://www.techradar.com/how-to/internet/cloud-services/how-to-recover-delet...
Laurie
On 13 August 2016 at 23:14, Sytze de Boer sytze.kiss@gmail.com wrote:
I have a client who has now lost their transaction history file for the 2nd time. By that I mean, all records between 23rd of March and sometime in August 2016
I've checked the file. The records are not there with a deleted flag. They're gone, as if deleted and packed.
It's most bizarre, and of course, my system gets the blame.
About the only thing I've noticed with their system is they run iCloud on their Windows 10 pc. It pops up about every 15 secs in the right hand system tray, to say it has synchronised some files.
My system has maybe 75 free standing dbf/fpt/cdx files. The corrupted history file only has about 10,000 records, where, on 2 occasions, 120 records have disappeared.
Does anyone wish to comment.
-- Kind regards, Sytze de Boer
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]
Does that iCloud system tray program lock files when doing the sync? That might cause conflicts with Foxpro's locking.
You might wanna exclude the Foxpro data folder in that iCloud program, or move the data folder to somewhere else?
On Sun, Aug 14, 2016 at 6:14 AM, Sytze de Boer sytze.kiss@gmail.com wrote:
About the only thing I've noticed with their system is they run iCloud on their Windows 10 pc. It pops up about every 15 secs in the right hand system tray, to say it has synchronised some files.
My system has maybe 75 free standing dbf/fpt/cdx files. The corrupted history file only has about 10,000 records, where, on 2 occasions, 120 records have disappeared.
Does anyone wish to comment.
Online backup services like iCloud or MozyPro are not a good idea for backing up VFP data.
Just curious, Alan. What makes you say that?
Mike
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Alan Bourke Sent: Monday, August 15, 2016 12:32 AM To: profoxtech@leafe.com Subject: Re: iCloud
Online backup services like iCloud or MozyPro are not a good idea for backing up VFP data.
-- Alan Bourke alanpbourke (at) fastmail (dot) fm
On Mon, 15 Aug 2016, at 04:49 AM, Man-wai Chang wrote:
Does that iCloud system tray program lock files when doing the sync? That might cause conflicts with Foxpro's locking.
You might wanna exclude the Foxpro data folder in that iCloud program, or move the data folder to somewhere else?
On Sun, Aug 14, 2016 at 6:14 AM, Sytze de Boer sytze.kiss@gmail.com wrote:
About the only thing I've noticed with their system is they run iCloud on their Windows 10 pc. It pops up about every 15 secs in the right hand system tray, to say it has synchronised some files.
My system has maybe 75 free standing dbf/fpt/cdx files. The corrupted history file only has about 10,000 records, where, on 2 occasions, 120 records have disappeared.
Does anyone wish to comment.
-- .~. Might, Courage, Vision. SINCERITY! / v \ 64-bit Ubuntu 9.10 (Linux kernel 2.6.39.3) /( _ )\ http://sites.google.com/site/changmw ^ ^ May the Force and farces be with you!
[excessive quoting removed by server]
On Mon, 15 Aug 2016, at 03:24 PM, Michael Glassman wrote:
Just curious, Alan. What makes you say that?
Michael
Firstly I've seen a few (MozyPro in particular) hold a file handle on DBF/FPT/CDX files if they're in the backup upload queue, which can interfere with VFP.
Secondly VFP applications using DBF data are essentially a data set spread over many files, hundreds in our case. Unless you can do a 'point in time' backup when you know there is nobody in the system (like the traditional 3AM tape backup approach) then how do you know if restored data is consistent?
Thanks for providing more details, Alan. Those are the same reasons I don't do continuous backups.
Mike
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Alan Bourke Sent: Monday, August 15, 2016 8:57 AM To: profoxtech@leafe.com Subject: Re: iCloud
On Mon, 15 Aug 2016, at 03:24 PM, Michael Glassman wrote:
Just curious, Alan. What makes you say that?
Michael
Firstly I've seen a few (MozyPro in particular) hold a file handle on DBF/FPT/CDX files if they're in the backup upload queue, which can interfere with VFP.
Secondly VFP applications using DBF data are essentially a data set spread over many files, hundreds in our case. Unless you can do a 'point in time' backup when you know there is nobody in the system (like the traditional 3AM tape backup approach) then how do you know if restored data is consistent?
-- Alan Bourke alanpbourke (at) fastmail (dot) fm
[excessive quoting removed by server]
I would suggest using some freeware to zip the VFP Dbc/Dbfs/Fpts/Idx/Cdx files before the zip file is copied to the iCloud.
You would require to schedule the Zip & Copy.
Most files aren't copied while being in use. Hence you might not have had the Transaction file getting copied since they would have been opened by the user(s) while the same was being copied.
On Monday 15 August 2016, Michael Glassman MHGlassman@pioneerdrama.com wrote:
Thanks for providing more details, Alan. Those are the same reasons I don't do continuous backups.
Mike
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com javascript:;] On Behalf Of Alan Bourke Sent: Monday, August 15, 2016 8:57 AM To: profoxtech@leafe.com javascript:; Subject: Re: iCloud
On Mon, 15 Aug 2016, at 03:24 PM, Michael Glassman wrote:
Just curious, Alan. What makes you say that?
Michael
Firstly I've seen a few (MozyPro in particular) hold a file handle on DBF/FPT/CDX files if they're in the backup upload queue, which can interfere with VFP.
Secondly VFP applications using DBF data are essentially a data set spread over many files, hundreds in our case. Unless you can do a 'point in time' backup when you know there is nobody in the system (like the traditional 3AM tape backup approach) then how do you know if restored data is consistent?
-- Alan Bourke alanpbourke (at) fastmail (dot) fm
[excessive quoting removed by server]
Back in the day I had a routine that attempted to use shared all dbfs and would copy to the backup folder. If a table was not able to be used that was noted in the log. When done all files were zipped into a single file. User could then copy that to floppy disk via a multi disk param or just leave them were they were. Next backup run would remove all of those files and repeat the process.
Today you can copy them to a usb key, secondary drive or the cloud.
On Tue, Aug 16, 2016 at 8:19 AM, Srikanth Bhandari < consultant@srikanthbhandari.ind.in> wrote:
I would suggest using some freeware to zip the VFP Dbc/Dbfs/Fpts/Idx/Cdx files before the zip file is copied to the iCloud.
You would require to schedule the Zip & Copy.
Most files aren't copied while being in use. Hence you might not have had the Transaction file getting copied since they would have been opened by the user(s) while the same was being copied.
On Monday 15 August 2016, Michael Glassman MHGlassman@pioneerdrama.com wrote:
Thanks for providing more details, Alan. Those are the same reasons I don't do continuous backups.
Mike
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com javascript:;] On Behalf Of Alan Bourke Sent: Monday, August 15, 2016 8:57 AM To: profoxtech@leafe.com javascript:; Subject: Re: iCloud
On Mon, 15 Aug 2016, at 03:24 PM, Michael Glassman wrote:
Just curious, Alan. What makes you say that?
Michael
Firstly I've seen a few (MozyPro in particular) hold a file handle on DBF/FPT/CDX files if they're in the backup upload queue, which can interfere with VFP.
Secondly VFP applications using DBF data are essentially a data set
spread
over many files, hundreds in our case. Unless you can do a 'point in
time'
backup when you know there is nobody in the system (like the traditional 3AM tape backup approach) then how do you know if restored data is
consistent?
-- Alan Bourke alanpbourke (at) fastmail (dot) fm
[excessive quoting removed by server]
...unless you know how to:
1. encrypt/decrypt the data 2. guarantee the connection is reliable 3. deal with sudden network partitioning
Personally, I don't trust these off-site data servers. I prefer keeping my stuffs in my home. :)
On Mon, Aug 15, 2016 at 2:31 PM, Alan Bourke alanpbourke@fastmail.fm wrote:
Online backup services like iCloud or MozyPro are not a good idea for backing up VFP data.
I would be more worried about giving personal data to search engines.
On Wed, Aug 17, 2016 at 6:11 AM, Man-wai Chang changmw@gmail.com wrote:
...unless you know how to:
- encrypt/decrypt the data
- guarantee the connection is reliable
- deal with sudden network partitioning
Personally, I don't trust these off-site data servers. I prefer keeping my stuffs in my home. :)
On Mon, Aug 15, 2016 at 2:31 PM, Alan Bourke alanpbourke@fastmail.fm wrote:
Online backup services like iCloud or MozyPro are not a good idea for backing up VFP data.
-- .~. Might, Courage, Vision. SINCERITY! / v \ 64-bit Ubuntu 9.10 (Linux kernel 2.6.39.3) /( _ )\ http://sites.google.com/site/changmw ^ ^ May the Force and farces be with you!
[excessive quoting removed by server]
On 17 Aug 2016 12:11, "Man-wai Chang" changmw@gmail.com wrote:
...unless you know how to:
- encrypt/decrypt the data
- guarantee the connection is reliable
- deal with sudden network partitioning
Personally, I don't trust these off-site data servers. I prefer keeping my stuffs in my home. :)
I've been running OwnCloud recently. Seems quite nice.
I agree that internet is fairly stable and most ISPs are providing reliable connections to it.
But what if.... properly designed/written applications must handle the errors no matter how unlikely they were.
On Thu, Aug 18, 2016 at 12:35 AM, Paul Hill paulroberthill@gmail.com wrote:
I've been running OwnCloud recently. Seems quite nice.
Just wondering where all his/her backups are between 23rd March and August?
Peter Cushing IT Department WHISPERING SMITH
On 13/08/2016 23:14, Sytze de Boer wrote:
I have a client who has now lost their transaction history file for the 2nd time. By that I mean, all records between 23rd of March and sometime in August 2016
I've checked the file. The records are not there with a deleted flag. They're gone, as if deleted and packed.
It's most bizarre, and of course, my system gets the blame.
About the only thing I've noticed with their system is they run iCloud on their Windows 10 pc. It pops up about every 15 secs in the right hand system tray, to say it has synchronised some files.
My system has maybe 75 free standing dbf/fpt/cdx files. The corrupted history file only has about 10,000 records, where, on 2 occasions, 120 records have disappeared.
Does anyone wish to comment.
This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email.
www.whisperingsmith.com
Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3 1RR. Tel:0161 831 3700 Fax:0161 831 3715
London Office:17-19 Foley Street, London W1W 6DW Tel:0207 299 7960
-
Alan Bourke -
Laurie Alvey -
Man-wai Chang -
Michael Glassman -
Paul Hill -
Peter Cushing -
Srikanth Bhandari -
Stephen Russell -
Sytze de Boer