I use Mozy for one of my off-site backups. The 'Volume Shadow Copy' service must be running.
Customized Business Services, LLC (928) 580-6352 Dennis Schuette Primary: [email protected] 350 West 16th Street, Suite 309 Alternate: [email protected] Yuma, AZ 85364 Map it -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Alan Bourke Sent: Sunday, November 24, 2013 1:02 AM To: [email protected] Subject: Re: Strange File In Use Error #3 - Solved Use of handle.exe or Process Monitor from Sysinternals, run on the server, will always show if there are open handles on it. We have a site where like idiots they are backing up all their VFP data using MozyPro, and if VFP files end up in the MozyPro upload queue then this sort of thing happens. On Sat, Nov 23, 2013, at 03:21 PM, Jeff Johnson wrote: > I have seen this before. A file gets stuck in the open position with > no program attached to it. You can't open it exclusive even though > there is nothing running in the task manager that is holding that file. > Rebooting the server solved the problem. > > Jeff > > Jeff Johnson > SanDC, Inc. > (623)-582-0323 > > www.san-dc.com <http://www.san-dc.com> www.cremationtracker.com > <http://www.cremationtracker.com> www.arelationshipmanager.com > <http://www.arelationshipmanager.com> > > > On 11/22/2013 9:03 AM, Jeff Johnson wrote: > > On 11/22/2013 8:54 AM, Tracy Pearson wrote: > >> Jeff Johnson wrote on 2013-11-22: > >>> I have a site that has been working fine for years. All of a > >>> sudden one > >>> file is throwing the above error on one table only. You can view the > >>> table fine. The problem is on add. There is a stored procedure that > >>> bumps up the primary key on add. When the stored procedure is > >>> called it > >>> throws an error number 3 File In Use. Here is the stored procedure. > >>> * Lock until user presses Esc > >>> SET REPROCESS TO AUTOMATIC > >>> IF NOT USED('id') > >>> USE broker!ID IN 0 > >>> ENDIF > >>> SELECT ID > >>> ********************** > >>> SET ORDER TO TAG TABLE > >>> ********************** > >>> SEEK (tcAlias) > >>> IF FOUND() > >>> IF RLOCK() > >>> lnID = ID.nextid > >>> REPLACE ID.nextid WITH ID.nextid + 1 > >>> UNLOCK > >>> ENDIF > >>> ENDIF > >>> SELECT ID > >>> USE > >>> SELECT (lnoldarea) > >>> SET REPROCESS TO lcoldreprocess > >>> Any ideas? > >> Jeff, > >> > >> I suspect it is on the USE command. I have customers get this > >> behavior when they have aggressive anti-virus or on demand backup > >> tools that will put a temporary lock on a file that was just > >> updated. > >> > >> Tracy Pearson > >> PowerChurch Software > >> > > > > Tracy: The stored procedure is working on all the other tables > > except this one. It just started yesterday. > > > > Jeff > > > > Jeff Johnson > > SanDC, Inc. > > (623)-582-0323 > > > > www.san-dc.com <http://www.san-dc.com> www.cremationtracker.com > > <http://www.cremationtracker.com> www.arelationshipmanager.com > > <http://www.arelationshipmanager.com> > > > > > > > > > > > > --- StripMime Report -- processed MIME parts --- > > multipart/alternative text/plain (text body -- kept) > > multipart/related > > text/html > > image/jpeg > > --- > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** 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.
