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 11: | Line 11: | ||
<big>'''Solution:'''</big> | <big>'''Solution:'''</big> | ||
: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 root | ::Firebird folder under '''c:\Program Files''' root | ||
cd c:\Program Files\Firebird\Firebird_3_0 | cd c:\Program Files\Firebird\Firebird_3_0 | ||
::Firebird folder under | ::Firebird folder under '''c:\''' root | ||
cd c:\Firebird\Firebird_3_0 | cd c:\Firebird\Firebird_3_0 | ||
[[File: | [[File:07-FAQ-02.jpg|800px]] | ||
<br /> | |||
:3. Under the root...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. |
Revision as of 04:44, 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.
- 2. Found the filename ACC-XXXXX.FDB.delta in DB folder. DO NOT remove this file.
Solution:
- 1. Run CMD.
- 2. Type the following command and hit <ENTER>.
- Firebird folder under c:\Program Files root
cd c:\Program Files\Firebird\Firebird_3_0
- Firebird folder under c:\ root
cd c:\Firebird\Firebird_3_0
- 3. Under the root...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.