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
 
(5 intermediate revisions by one other user not shown)
Line 6: Line 6:
  
 
: 2. Found the filename '''ACC-XXXXX.FDB.delta''' in DB folder. '''DO NOT''' remove this file.  
 
: 2. Found the filename '''ACC-XXXXX.FDB.delta''' in DB folder. '''DO NOT''' remove this file.  
[[File:07-FAQ-01.jpg |800px]]
+
::[[File:07-FAQ-01.jpg |500px]]
 
<br />
 
<br />
  
 
<big>'''Solution:'''</big>  
 
<big>'''Solution:'''</big>  
:1. Run '''CMD'''.
+
:1. Run '''CMD''' as Administrator
 
: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 root '''c:\Program Files'''
 
   cd c:\Program Files\Firebird\Firebird_3_0  
 
   cd c:\Program Files\Firebird\Firebird_3_0  
  
::Firebird folder under '''c:\''' root
+
::Firebird folder under root '''c:\'''
 
   cd c:\Firebird\Firebird_3_0  
 
   cd c:\Firebird\Firebird_3_0  
  
[[File:07-FAQ-02.jpg|800px]]
+
::[[File:07-FAQ-02.jpg|500px]]
 
<br />
 
<br />
  
:3. Under the root...Firebird\Firebird_3_0, type the following command and hit '''<ENTER>'''.
+
:3. Under the root c:\...Firebird\Firebird_3_0, type the following command and hit '''<ENTER>'''.
 
   set isc_user=sysdba
 
   set isc_user=sysdba
 +
 +
:4. Under the root c:\...Firebird\Firebird_3_0, type the following command and hit '''<ENTER>'''.
 
   set isc_password=masterkey
 
   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. Under the root c:\...Firebird\Firebird_3_0, type the following command and hit '''<ENTER>'''.
:5. Login the database and run backup at File | Backup Database as normal.
+
  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.

Latest revision as of 01:47, 4 January 2020

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.