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

From eStream Software
Jump to: navigation, search
Line 11: Line 11:
 
<big>'''Solution:'''</big>  
 
<big>'''Solution:'''</big>  
 
:1. Run '''CMD'''.
 
: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  
 
   cd c:\Program Files\Firebird\Firebird_3_0  
  
::Firebird folder under C:\ root
+
::Firebird folder under '''c:\''' root
 
   cd c:\Firebird\Firebird_3_0  
 
   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.

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.

07-FAQ-01.jpg

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 

07-FAQ-02.jpg

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.