1. Backup error unsuccessful metadata update and database is already in the physical backup mode: Difference between revisions
From eStream Software
No edit summary |
No edit summary |
||
Line 10: | Line 10: | ||
<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 root '''c:\Program Files''' | ::Firebird folder under root '''c:\Program Files''' |
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.
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
- 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.