Were were just having real issues of slowness on our W2008R2 servers (VM). That has all gone away with the W2019 servers (VM). We never have had a big issue with data corruption, I think only one file in over 10 years. Our system is about 30 users, 2 remote access through RDP and VPN.
Fred
On Thu, Mar 21, 2019 at 10:23 AM Tracy Pearson tracy@powerchurch.com wrote:
Fred, I'm curious if your setup has data on one server, and the VFP applications are on another server. If they are setup this way, how much activity do the VFP data files get?
And for everyone else... I know we have trouble with index corruption. It is partly the VM server hosting the data gets a little overwhelmed from time to time, and partly due to how this 30+ year code base uses the tables. We have over 600 users connecting to one of 18 VM's which access various datasets on one of four VM's during our peak times of the week. Corruption seems to be an everyday thing. We have some crucial areas that depend on the indexes. In these areas, we have implemented code to verify or just reindex the files when the user goes in to the process. We also delete and create the indexes daily for some customers (maybe 20 out of 3600+).
Have a good one, Tracy
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Fred Taylor Sent: Thursday, March 21, 2019 12:05 PM To: profoxtech@leafe.com Subject: Re: File Access Issues
We recently upgraded to a new server box from running Windows Server 2008 (3 VM's) to Windows Server 2019 (running 6 VM's). Most of the VM's have access to FoxPro data and function without incident.
Have you made sure that Windows Defender has also been set to ignore .DBF/.CDX/.FPT files on both the servers and the workstations?
Fred
On Thu, Mar 21, 2019 at 2:42 AM Chris Davis chrisd@actongate.co.uk wrote:
We are seeing increasing problems with VFP applications (some of our own and other commercial ones) as our customers have their servers upgraded.
A lot of these servers are now virtual machines hosted on a physical machine. In some instances these are remote desktop servers which access the VFP data from a different server.
The file access issues seem to be random, in some instances the indexes get corrupted and need to be repaired.
Anti Virus has been ruled out by uninstalling it, but the problems
persist.
Any ideas? Any issues with VFP data and VM's?
Regards
Chris.
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]