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 24: | Line 24: | ||
set isc_user=sysdba | set isc_user=sysdba | ||
set isc_password=masterkey | set isc_password=masterkey | ||
nbackup -unlock C:\eStream\SQLAccounting\DB\ACC-XXXXX.FDB | nbackup -unlock '''C:\eStream\SQLAccounting\DB\ACC-XXXXX.FDB''' | ||
:4. You will found the ACC-XXXXX.FDB.delta file will be removed automatically. | :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. | :5. Login the database and run backup at File | Backup Database as normal. |
Revision as of 04:48, 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.
Solution:
- 1. Run CMD.
- 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 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.