Strange Data Corruption Issue

2009-10-27 Thread Aida I . Rivera-Benítez , MSMIS
Hi to all! Have a client with a strange data corruption issue. When I went to the site was receiving a "Not a Table" message. I said to myself, piece of cake, just fix the affected table(s) or restore from a backup and go on. But when I tried to fix the tables received another err

Re: Strange Data Corruption Issue

2009-10-27 Thread MB Software Solutions, LLC
Aida I. Rivera-Benítez wrote: > Hi to all! > > Have a client with a strange data corruption issue. When I went to the site > was receiving a "Not a Table" message. I said to myself, piece of cake, > just > fix the affected table(s) or restore from a backup and g

RE: Strange Data Corruption Issue

2009-10-27 Thread Allen
:28 To: profoxt...@leafe.com Subject: Re: Strange Data Corruption Issue Aida I. Rivera-Benítez wrote: > Hi to all! > > Have a client with a strange data corruption issue. When I went to the site > was receiving a "Not a Table" message. I said to myself, piece of cake, >

RE: Strange Data Corruption Issue

2009-10-27 Thread Aida I . Rivera-Benítez , MSMIS
: Tuesday, October 27, 2009 10:49 AM To: profox@leafe.com Subject: RE: Strange Data Corruption Issue Check the write ahead cache on the disk drive too. I think this went back to NT4 days when they (M$) started playing with cache. Al ___ Post Messages to

RE: Strange Data Corruption Issue

2009-10-27 Thread Aida I . Rivera-Benítez , MSMIS
Thanks Mike! Will do that before I leave to make sure, still checking if I find something else, think you are close is something like that ... a program is installed that somehow got inside the file and replaced it with spaces, it could be the AV or other similar programs ... looking into that rig

RE: Strange Data Corruption Issue

2009-10-27 Thread Christof Wollenhaupt
> I don't think so, worked in this scenario before and the tables either dissapear completely (files deleted) or some records are replaced or added with junk values Actually, there's a possibility to get files like these. It's even built into Windows and called NTFS. When you change or update file

RE: Strange Data Corruption Issue

2009-10-27 Thread Eurico Chagas Filho
Hi It happened to me when I unplugged my laptop before it finished the shut down stuff. E. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailma

Re: Strange Data Corruption Issue

2009-10-27 Thread MB Software Solutions, LLC
Aida I. Rivera-Benítez wrote: > Thanks Mike! > > Will do that before I leave to make sure, still checking > if I find something else, think you are close is something > like that ... a program is installed that somehow got inside > the file and replaced it with spaces, it could be the AV or > othe

Re: Strange Data Corruption Issue

2009-10-27 Thread Paul Hill
On Tue, Oct 27, 2009 at 2:27 PM, MB Software Solutions, LLC wrote: > In our Best Practices document here at the day-job, we advise our > customers to exclude our program and data folders from the A/V scans. Me too. Speaking of which, has anyone come across the SMB2 issue with delayed file creati

RE: Strange Data Corruption Issue

2009-10-28 Thread Aida I . Rivera-Benítez , MSMIS
Well I found the problem! or the problem found me... The hard disk crashed gave me a dump error message, showed the blue screen of dead and later finally died. After the funeral, reinstalled in another computer and let them working. Thanks to all for the excellent suggestions! Regards. AiR

Re: Strange Data Corruption Issue

2009-10-28 Thread Ajoy Khaund
t; Sent: Tuesday, October 27, 2009 7:57 PM To: Subject: Re: Strange Data Corruption Issue > Aida I. Rivera-Benítez wrote: >> Hi to all! >> >> Have a client with a strange data corruption issue. When I went to the >> site >> was receiving a "Not a Table&quo

Re: Strange Data Corruption Issue

2009-10-28 Thread MB Software Solutions, LLC
Ajoy Khaund wrote: > Hey Michael, > > Can I have a copy of your best practices document if its not confidential. > > That sounds like a good idea to give clients. Well, I can't give you the official day-time gig document, but let me just sum it up: - use a UPS (uninterrupted power supply) to g

Re: Strange Data Corruption Issue

2009-10-29 Thread Michael Madigan
You should turn off Opportunistic locking on the computers too. --- On Thu, 10/29/09, MB Software Solutions, LLC wrote: > From: MB Software Solutions, LLC > Subject: Re: Strange Data Corruption Issue > To: "ProFox Email List" > Date: Thursday, October 29, 2009, 1:51

Re: Strange Data Corruption Issue

2009-10-29 Thread Ajoy Khaund
/ "Walking on water and developing software from a specification are easy if both are frozen." - Edward V. Berard, "Life-Cycle Approaches" -- From: "MB Software Solutions,LLC" Sent: Thursday, October 29, 2009 11:21 AM

RE: Strange Data Corruption Issue

2009-10-29 Thread Tracy Pearson
Right click "Computer" and select "Manage", you'll find "Disk Management" in there. Right click "Disk 0", you'll find the setting on the "Policies" tab. Or RUN "diskmgmt.msc" Or Right click a drive in Explore, "Properties", select Hardware, select the drive, select Properties (you may need to cli

Re: Strange Data Corruption Issue

2009-10-29 Thread Paul McNett
Tracy Pearson wrote: > There's a couple of programmatic ways, but I've not got that code handy > right now. If there's a programmatic way for a Windows client to tell if the server is using write caching, then your VFP program could give your user a warning: "Please turn write caching off on t

Re: Strange Data Corruption Issue

2009-10-29 Thread MB Software Solutions, LLC
Ajoy Khaund wrote: > Ok > > How do you disable disable write-behind caching on local and network drives > ? http://lmgtfy.com/?q=disabling+write-behind+caching -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com

Re: Strange Data Corruption Issue

2009-10-29 Thread MB Software Solutions, LLC
Paul McNett wrote: > Tracy Pearson wrote: >> There's a couple of programmatic ways, but I've not got that code handy >> right now. > > If there's a programmatic way for a Windows client to tell if the server is > using > write caching, then your VFP program could give your user a warning: "Pleas

RE: Strange Data Corruption Issue

2009-10-29 Thread Allen
You're not kidding Al -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions, LLC Paul McNett wrote: > Tracy Pearson wrote: >> There's a couple of programmatic ways, but I've not got that code handy >> right now. >

RE: Strange Data Corruption Issue

2009-10-29 Thread Tracy Pearson
The catch is this has to be run where the data is stored. You can't tell from a workstation if a server drive has the cache on. I'll look it up again tonight and get back here with it. Tracy -Original Message- From: Paul McNett Sent: Thursday, October 29, 2009 10:53 AM Tracy Pearson wro