1. Backup error unsuccessful metadata update and database is already in the physical backup mode

From eStream Software
Revision as of 01:47, 4 January 2020 by Twfaung (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Symptoms :

1. The following error message prompted during the backup process.
unsuccessful metadata update
ALTER DATABASE failed
Database is already in the physical backup mode.
2. Found the filename ACC-XXXXX.FDB.delta in DB folder. DO NOT remove this file.
07-FAQ-01.jpg


Solution:

1. Run CMD as Administrator
2. Type the following command and hit <ENTER>.
Firebird folder under root c:\Program Files
 cd c:\Program Files\Firebird\Firebird_3_0 
Firebird folder under root c:\
 cd c:\Firebird\Firebird_3_0 
07-FAQ-02.jpg


3. Under the root c:\...Firebird\Firebird_3_0, type the following command and hit <ENTER>.
 set isc_user=sysdba
4. Under the root c:\...Firebird\Firebird_3_0, type the following command and hit <ENTER>.
 set isc_password=masterkey
5. Under the root c:\...Firebird\Firebird_3_0, type the following command and hit <ENTER>.
 nbackup -unlock C:\eStream\SQLAccounting\DB\ACC-XXXXX.FDB
6. You will found the ACC-XXXXX.FDB.delta file will be removed automatically.
7. Login the database and run backup at File | Backup Database as normal.