Subject | How to restore and save the original DB file? |
---|---|
Author | Chuck Belanger |
Post date | 2012-04-06T08:39:26Z |
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
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