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

Revision as of 04:44, 9 August 2019

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.

Solution:

1. Run CMD.

2. Type the following command and hit <ENTER>.

Firebird folder under c:\Program Files root

 cd c:\Program Files\Firebird\Firebird_3_0

Firebird folder under c:\ root

 cd c:\Firebird\Firebird_3_0

3. Under the root...Firebird\Firebird_3_0, type the following command and hit <ENTER>.

 set isc_user=sysdba
 set isc_password=masterkey
 nbackup -unlock C:\eStream\SQLAccounting\DB\ACC-XXXXX.FDB

4. You will found the ACC-XXXXX.FDB.delta file will be removed automatically.

5. Login the database and run backup at File | Backup Database as normal.

@@ Line 11: / Line 11: @@
 <big>'''Solution:'''</big>
 :1. Run '''CMD'''.
-:2. Type the following command and hit ENTER.
+:2. Type the following command and hit '''<ENTER>'''.
-::Firebird folder under c:\Program Files root
+::Firebird folder under '''c:\Program Files''' root
    cd c:\Program Files\Firebird\Firebird_3_0
-::Firebird folder under C:\ root
+::Firebird folder under '''c:\''' root
    cd c:\Firebird\Firebird_3_0
-:3.
-[[File:05-FAQ-01.jpg|800px]]
+[[File:07-FAQ-02.jpg|800px]]
+<br />
+:3. Under the root...Firebird\Firebird_3_0, type the following command and hit '''<ENTER>'''.
+  set isc_user=sysdba
+  set isc_password=masterkey
+  nbackup -unlock C:\eStream\SQLAccounting\DB\ACC-XXXXX.FDB
+:4. You will found the ACC-XXXXX.FDB.delta file will be removed automatically.
+:5. Login the database and run backup at File | Backup Database as normal.