RE: Strange Data Corruption Issue
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 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 the server, or data corruption is likely to occur" or "We will not run until write caching is turned off" would probably be more effective. Paul ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/000301ca58aa$e5d6baa0$b1842f...@com ** 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.
RE: Strange Data Corruption Issue
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. > > 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 the server, or data corruption is likely to occur" or "We will > not run until write caching is turned off" would probably be more effective. > > Paul I'd very much like that, if someone has that code handy. ;-) ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/004601ca58aa$f30fbd20$d92f37...@com ** 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.
Re: Strange Data Corruption Issue
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: "Please > turn > write caching off on the server, or data corruption is likely to occur" or > "We will > not run until write caching is turned off" would probably be more effective. > > Paul I'd very much like that, if someone has that code handy. ;-) -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/4ae9afbc.9020...@mbsoftwaresolutions.com ** 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.
Re: Strange Data Corruption Issue
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 http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/4ae9af79.4050...@mbsoftwaresolutions.com ** 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.
Re: Strange Data Corruption Issue
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 the server, or data corruption is likely to occur" or "We will not run until write caching is turned off" would probably be more effective. Paul ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/4ae9ac56.3090...@ulmcnett.com ** 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.
RE: Strange Data Corruption Issue
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 click "Change Settings" on the "General" tab, then select "Policies" tab. There's a couple of programmatic ways, but I've not got that code handy right now. "Enable write caching on the disk" should not be checked. -Original Message- From: Ajoy Khaund Sent: Thursday, October 29, 2009 10:13 AM Ok How do you disable disable write-behind caching on local and network drives ? Regards Ajoy Khaund Neamati Road Near Bhogdoi Bridge Jorhat 785001-21 Assam, India ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/000201ca58a3$f531de00$df959a...@com ** 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.
Re: Strange Data Corruption Issue
Ok How do you disable disable write-behind caching on local and network drives ? Regards Ajoy Khaund Neamati Road Near Bhogdoi Bridge Jorhat 785001-21 Assam, India Tel: 91-376-2351288 Cell: 91-94350-92287 Mail: akha...@hotmail.com Mail: akha...@gmail.com http://teaanalyst.blogspot.com/ "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 To: Subject: Re: Strange Data Corruption Issue > 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 guard against data > loss/corruption due to power fluctuation > - make backups daily (our software has its own backup mechanism) > - run the cleanup daily (our software has its own cleanup routine for > packing data and trying to enforce SOME sort of referential integrity) > - configure the anti-virus software to EXCLUDE our application and data > folders > - disable write-behind caching on local and network drives > > > -- > Mike Babcock, MCP > MB Software Solutions, LLC > President, Chief Software Architect > http://mbsoftwaresolutions.com > http://fabmate.com > http://twitter.com/mbabcock16 > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/afc96dfbb7124a079f9cdd51c444b...@compaq ** 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.
Re: Strange Data Corruption Issue
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 AM > 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 guard against > data > loss/corruption due to power fluctuation > - make backups daily (our software has its own backup > mechanism) > - run the cleanup daily (our software has its own cleanup > routine for > packing data and trying to enforce SOME sort of referential > integrity) > - configure the anti-virus software to EXCLUDE our > application and data > folders > - disable write-behind caching on local and network drives > > > -- > Mike Babcock, MCP > MB Software Solutions, LLC > President, Chief Software Architect > http://mbsoftwaresolutions.com > http://fabmate.com > http://twitter.com/mbabcock16 > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/368109.26634...@web31408.mail.mud.yahoo.com ** 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.
Re: Strange Data Corruption Issue
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 guard against data loss/corruption due to power fluctuation - make backups daily (our software has its own backup mechanism) - run the cleanup daily (our software has its own cleanup routine for packing data and trying to enforce SOME sort of referential integrity) - configure the anti-virus software to EXCLUDE our application and data folders - disable write-behind caching on local and network drives -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/4ae92d61.9000...@mbsoftwaresolutions.com ** 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.
Re: Strange Data Corruption Issue
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. Regards Ajoy Khaund Neamati Road Near Bhogdoi Bridge Jorhat 785001-21 Assam, India Tel: 91-376-2351288 Cell: 91-94350-92287 Mail: akha...@hotmail.com Mail: akha...@gmail.com http://teaanalyst.blogspot.com/ "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: 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" 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 error and for the first time in more than >> 20 >> years >> my fixdbf program didn't work. Upon further inspection of the affected >> tables (8), >> noticed that the contents was not there, there were filled with spaces, >> so >> no wonder, >> nothing to recover. >> >> Had to restore from a backup and that solve the problem. Now I'm >> wondering >> is it a >> hard disk crashing or network failure, well 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, or is there any utility or antivirus that does >> this? so I can remove it. >> >> Regards. > > > Hi Aida, > > 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. > > -- > Mike Babcock, MCP > MB Software Solutions, LLC > President, Chief Software Architect > http://mbsoftwaresolutions.com > http://fabmate.com > http://twitter.com/mbabcock16 > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/af59fb8e0fd5434ab0410c517c352...@compaq ** 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.
RE: Strange Data Corruption Issue
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 Aida I. Rivera-Benítez, MSMIS AiR Information Systems, Inc. San Juan, Puerto Rico www.airispro.com ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/4b08c15740b94502981b22237647e...@billingserver ** 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.
Re: Strange Data Corruption Issue
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 creation?
It only affects Vista/Windows 7 & Windows Server 2008 (XP+2008 is OK,
Vista/7+2003 is OK).
There can be a 10 second delay after creating a file on a network
drive before it appears in the directory.
So if you do something like:
COPY "src.txt" TO "dst.txt"
IF File("dst.txt")
...
ENDIF
The File() call can fail. Actually I'm not sure if File() has a
problem but something like ADIR() certainly does. One solution is to
switch off SMB2, but I don't particularly like that.
See:
http://blogs.msdn.com/winsdk/archive/2009/07/10/file-exists-access-getfileattributes-findfirstfile-findnextfile-stat-behavior-over-smb-2-0.aspx
Problem Observed: When an application on client creates a file on a
shared directory on server or application on server creates a file on
shared directory on server, and file is created successfully but when
the application on client try to check the existence of the recently
created file by _access or other method, it reports that the file does
not exists. This behavior is observed when SMB 2.0 is used.
--
Paul
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/17cad13c0910271542w5c857625mb91f2d0406532...@mail.gmail.com
** 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.
Re: Strange Data Corruption Issue
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 > other similar programs ... looking into that right now. > > AiR > > Aida I. Rivera-Benítez, MSMIS > AiR Information Systems, Inc. > San Juan, Puerto Rico > www.airispro.com > >> 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. > We also suggest the disabling of the write-cache, as someone else here suggested. Also, UPS (battery backups) on the machines. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/4ae73d00.20...@mbsoftwaresolutions.com ** 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.
RE: Strange Data Corruption Issue
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/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/d9a516403a2b4f0a9dafea236b944...@notebookhp ** 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.
RE: Strange Data Corruption Issue
> 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 files on an NTFS formatted drive, NTFS keeps track of changes in a transaction log. Sometimes, shutting down the computer can take an awful long time while the hard disk is constantly spinning. Last time I had this happen to me was when I was shutting down a vmware and then shutting down the laptop. After 30-40 minutes of staring at the "please wait... System is shutting down" message, I finally turned off the computer briskly. When I turned it on again I didn't immediately note any problems. All my files where there. Only when I continued working on a program file I realized that Windows had filled many files with CHR(0) that I changed up to around 15 minutes before shutting down my system. The file size was correct, just the content was gone. I assume that rolling back the transaction log didn't work out too well. -- Christof ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/3d325e918eae4dc18a3440928ca73...@fpl5 ** 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.
RE: Strange Data Corruption Issue
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 right now. AiR Aida I. Rivera-Benítez, MSMIS AiR Information Systems, Inc. San Juan, Puerto Rico www.airispro.com >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. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/1eac4bd464a14c1682666750c5549...@billingserver ** 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.
RE: Strange Data Corruption Issue
Thanks Allen. Always turn off the cache, just rechecked is still off. AiR Aida I. Rivera-Benítez, MSMIS AiR Information Systems, Inc. San Juan, Puerto Rico www.airispro.com -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Allen Sent: 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: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/dda2a4080c524914bc153165c2efc...@billingserver ** 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.
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 -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: 27 October 2009 15: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, > just > fix the affected table(s) or ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/001c01ca5714$97f811e0$c7e835...@com ** 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.
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, > just > fix the affected table(s) or restore from a backup and go on. But when I > tried to > fix the tables received another error and for the first time in more than 20 > years > my fixdbf program didn't work. Upon further inspection of the affected > tables (8), > noticed that the contents was not there, there were filled with spaces, so > no wonder, > nothing to recover. > > Had to restore from a backup and that solve the problem. Now I'm wondering > is it a > hard disk crashing or network failure, well 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, or is there any utility or antivirus that does > this? so I can remove it. > > Regards. Hi Aida, 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. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/4ae7035d@mbsoftwaresolutions.com ** 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.
Strange Data Corruption Issue
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 error and for the first time in more than 20 years my fixdbf program didn't work. Upon further inspection of the affected tables (8), noticed that the contents was not there, there were filled with spaces, so no wonder, nothing to recover. Had to restore from a backup and that solve the problem. Now I'm wondering is it a hard disk crashing or network failure, well 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, or is there any utility or antivirus that does this? so I can remove it. Regards. AiR Aida I. Rivera-Benítez, MSMIS AiR Information Systems, Inc. San Juan, Puerto Rico www.airispro.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/20a2179ef4914b75b30cdc6be5c11...@billingserver ** 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.
