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 12: | Line 12: | ||
: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''' | ::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:\''' | ::Firebird folder under root '''c:\''' | ||
cd c:\Firebird\Firebird_3_0 | cd c:\Firebird\Firebird_3_0 | ||
Line 21: | Line 21: | ||
<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 | ||
set isc_password=masterkey | set isc_password=masterkey |
Revision as of 04:47, 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.