It sounds to me like it is in use. The windows server can tell you who
is using it. I havent done it foe a while so I cant tell you how to
drill down to it.

Rohit

On 8/04/2012 8:43 a.m., Chuck Belanger wrote:
>
> Hi, Helen:
>
> Thanks for the response.
>
> No, this is all done locally with superserver. It is essentially a
> desktop program, which recently we added the ability to upload some data
> to an internet location, thus requiring that we go from embedded to
> fbclient with server.
>
> All systems use the same setup. That particular user happens to be the
> "tech support" guy for this program.
>
> My work around was to simply copy the current DB as a file backup, then
> restore to replace the current DB. I was worried the copy would be slow,
> but for the typical 100 - 1000 mb file it goes pretty quickly. The copy
> was allowed, but the deleting and renaming was not, at least on that one
> system.
>
> Chuck
> > At 08:39 PM 6/04/2012, Chuck Belanger wrote:
> >> Hello:
> >>
> >> I am using IBOAdmin components with IBO 4.8.7 in Delphi 2007 with
> FB 2.5
> >> server all on a local drive, single user system. What I am trying to do
> >> is make a restore by renaming the database then restoring to the
> >> original file name, so not as to overwrite the database.
> >>
> >> The problem is that in order to rename the DB file, I found that I have
> >> to disconnect then stop the service, rename, then restart the service
> >> then do the restore. I test to see if the DB file is in use by any
> >> process (the FB server) and then do the renaming. But, although this
> >> works for all 5 systems that I have and use for testing, I have one
> user
> >> on whose system, the DB file even after stopping the FB service, shows
> >> the DB file is still in use, which stops the restore since I am trying
> >> to avoid writing over it.
> >>
> >> At this point, I really do not know a way around this.
> >>
> >> Does anyone have a suggestion on how to restore and change file names
> >> without running into "file is in use by another process" type error.
> > It sounds as though that problem site is running Classic + Guardian,
> to cause this problem. Are you able to check? Guardian should *NOT* be
> allowed to run on a Classic installation.
> >
> > Helen
> >
> >
> >
> > ------------------------------------
> >
> > __________________________________________________________
> > IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
> > without the need for BDE, ODBC or any other layer.
> > __________________________________________________________
> > http://www.ibobjects.com - your IBO community resource for Tech Info
> papers,
> > keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links
> >
> >
> >
> >
>
>
>
>
> __________ Information from ESET NOD32 Antivirus, version of virus
> signature database 7036 (20120407) __________
>
> The message was checked by ESET NOD32 Antivirus.
>
> http://www.eset.com


--
Regards

*Rohit Gupta*
B.E. Elec., M.E., Mem IEEE, Member IET
Technical Director
Computer Fanatics Ltd

*Tel *4892280
*Fax *4892290
*Web *www.cfl.co.nz
------------------------------------------------------------------------
This email and any attachments contain information, which is
confidential and may be subject to legal privilege and copyright. If you
are not the intended recipient, you must not use, distribute or copy
this email or attachments. If you have received this in error, please
notify us immediately by return email and then delete this email and any
attachments.


[Non-text portions of this message have been removed]