Subject | Re: [firebird-support] Restore problem |
---|---|
Author | Dmitry Kuzmenko |
Post date | 2012-04-13T06:34:11Z |
Hello, Aage!
Friday, April 13, 2012, 1:44:34 AM, you wrote:
AJ> Fb/2.5 restoring Fb/1.5 database with (one single command line):
AJ> ==================================
AJ> gbak -se service_mgr
AJ> -fix_fss_metadata ISO8859_1
AJ> -fix_fss_data ISO8859_1
AJ> -rep -v -z
AJ> -user SYSDBA -password masterkey
AJ> E:\...\...\sl1b3_20120412.fbk15 SL1
AJ> ==================================
AJ> Previous restores have never failed.
mmm, you did this command SEVERAL TIMES???
AJ> I did not find any records with
AJ> ==================================
AJ> select *
AJ> from AKTIVITET
AJ> where IDNR is null
AJ> ==================================
AJ> And none should be found, AKTIVITET.IDNR - the primary key - cannot
AJ> be "Null" (right?).
it can, if index was corrupted.
alter that index active, and then try query again.
--
Dmitry Kuzmenko, www.ib-aid.com
Friday, April 13, 2012, 1:44:34 AM, you wrote:
AJ> Fb/2.5 restoring Fb/1.5 database with (one single command line):
AJ> ==================================
AJ> gbak -se service_mgr
AJ> -fix_fss_metadata ISO8859_1
AJ> -fix_fss_data ISO8859_1
AJ> -rep -v -z
AJ> -user SYSDBA -password masterkey
AJ> E:\...\...\sl1b3_20120412.fbk15 SL1
AJ> ==================================
AJ> Previous restores have never failed.
mmm, you did this command SEVERAL TIMES???
AJ> I did not find any records with
AJ> ==================================
AJ> select *
AJ> from AKTIVITET
AJ> where IDNR is null
AJ> ==================================
AJ> And none should be found, AKTIVITET.IDNR - the primary key - cannot
AJ> be "Null" (right?).
it can, if index was corrupted.
alter that index active, and then try query again.
--
Dmitry Kuzmenko, www.ib-aid.com