When I give wrong backup file to NBACKUP.exe -INPLACE, error is reported as expected:

NBACKUP -inplace -restore localhost/3333:Z:\export\TESTF2.FDB Z:\export\x05G.nbk
Invalid incremental backup file: Z:\export\x05G.nbk

NBACKUP -inplace -restore localhost/3333:Z:\export\TESTF2.FDB Z:\export\x05G.nbk
Invalid incremental backup file: Z:\export\x05G.nbk


But when I do the same using FB Services API (isc_action_svc_nrest, isc_spb_options+isc_spb_nbk_inplace, ...) then after the first error the database will remain locked, and all subsequent attempts to work with it raise:
  Statement failed, SQLSTATE = HY000
  Error opening database file: Z:\EXPORT\TESTF2.FDB
  -The process cannot access the file because it is being used by another process
The FB server must be restarted to unlock the file.

(tested with Firebird-4.0.0.1963-0-Beta2 and snapshot Firebird-4.0.0.1999-0_x64)

I also wanted to test it with FBSVCMGR.exe, but FBSVCMGR does not recognize switches isc_spb_options/isc_spb_nbk_inplace (neither of -isc_spb_options, -spb_options, -options)

Ivan



Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to