Subject How to restore and save the original DB file?
Author Chuck Belanger
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.

Thank you,

Chuck Belanger