Subject | Re: [firebird-support] Firebird shutdown, backup & restore possible with IBX? |
---|---|
Author | Mathias Burbach |
Post date | 2005-07-26T00:46:39Z |
Mathias wrote:
I gave it another go this morning with IBExpert only. I opened two
instances of IBExpert both using TCP/IP to connect to localhost and
using the FBClient.dll as the client library file. I connected with
instance 1 and shutdown the database with instance 2. Consequently I
lost my database connection in instance 1. Then I created a backup with
instance 2 and when I started to restore that backup I ran into an
error, which was much more descriptive:
IBE: Starting restore. Current time: 10:35:20
IBE: This operation is not defined for system tables.
unsuccessful metadata update.
object DATABASE is in use .
could not drop database [Drive]:\[Path]\[DatabaseName].FB (database
might be in use).
IBE: Restore completed. Current time: 10:35:20. Elapsed time: 00:00:00
It seems the shutdown causes that I loose my database connection in
instance 1 but some handle is still active in instance 1, which causes
that a restore with replace option fails. I will now try to do the same
with the Firebird command line tools and see if I run into the same error.
Salut,
Mathias
>By now I have downloaded the FIBPlus 6.25 trial version and ran into theHello Folks!
>*same* problem in IB_Services.pas on method
>TpFIBControlService.InternalServiceStart although I have set the
>LibraryName of all three FIBPlus components to 'C:\Program
>Files\Firebird\Firebird 1.5\bin\fbclient.dll'.
>
>Any ideas what I shall do to resolve this?
>
>
I gave it another go this morning with IBExpert only. I opened two
instances of IBExpert both using TCP/IP to connect to localhost and
using the FBClient.dll as the client library file. I connected with
instance 1 and shutdown the database with instance 2. Consequently I
lost my database connection in instance 1. Then I created a backup with
instance 2 and when I started to restore that backup I ran into an
error, which was much more descriptive:
IBE: Starting restore. Current time: 10:35:20
IBE: This operation is not defined for system tables.
unsuccessful metadata update.
object DATABASE is in use .
could not drop database [Drive]:\[Path]\[DatabaseName].FB (database
might be in use).
IBE: Restore completed. Current time: 10:35:20. Elapsed time: 00:00:00
It seems the shutdown causes that I loose my database connection in
instance 1 but some handle is still active in instance 1, which causes
that a restore with replace option fails. I will now try to do the same
with the Firebird command line tools and see if I run into the same error.
Salut,
Mathias