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 23: | Line 23: | ||
:3. Under the root c:\...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 | ||
: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''' | 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. |
Revision as of 04:50, 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
- 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.