Subject | RE: [firebird-support] restore single .gbk to multipe .fdb |
---|---|
Author | RB Smissaert |
Post date | 2007-10-06T22:09:52Z |
Figured out the syntax now to restore the IB .gbk file to multiple .fdb
files, and it seems to look good
with one large primary file of about 2 Gb and a smaller file of about 0.5
Gb. However when I test with
a query like this:
select max(entry_id) from entry on the largest table in the database it
shows there are a lot of rows missing.
This is what I ran with gbak:
gbak -c -p 4096 -v -user sysdba -password xxx C:\test\s6.gbk C:\test\s6.fdb
500000 C:\test\s6A.fdb
Any ideas what I might be doing wrong here?
RBS
_____
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of bartsmissaert
Sent: 06 October 2007 17:34
To: firebird-support@yahoogroups.com
Subject: [firebird-support] restore single .gbk to multipe .fdb
I have an Interbase .gbk file that needs restoring to multiple
.fdb files and I can't get the gbak syntax for this.
I have restored to a single .fdb file, but then there is data missing
and this must be because the .gbk is a backup of multiple .gdb files.
Have been looking for a free utility that does the re-store, but sofar
nil found yet.
In case it makes a difference, the .gbk is from IB 5.6 and I am using
FB 2.0,
Thanks for any advice.
RBS
[Non-text portions of this message have been removed]
files, and it seems to look good
with one large primary file of about 2 Gb and a smaller file of about 0.5
Gb. However when I test with
a query like this:
select max(entry_id) from entry on the largest table in the database it
shows there are a lot of rows missing.
This is what I ran with gbak:
gbak -c -p 4096 -v -user sysdba -password xxx C:\test\s6.gbk C:\test\s6.fdb
500000 C:\test\s6A.fdb
Any ideas what I might be doing wrong here?
RBS
_____
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of bartsmissaert
Sent: 06 October 2007 17:34
To: firebird-support@yahoogroups.com
Subject: [firebird-support] restore single .gbk to multipe .fdb
I have an Interbase .gbk file that needs restoring to multiple
.fdb files and I can't get the gbak syntax for this.
I have restored to a single .fdb file, but then there is data missing
and this must be because the .gbk is a backup of multiple .gdb files.
Have been looking for a free utility that does the re-store, but sofar
nil found yet.
In case it makes a difference, the .gbk is from IB 5.6 and I am using
FB 2.0,
Thanks for any advice.
RBS
[Non-text portions of this message have been removed]