Subject Re: [ib-support] Re: Restoring database > 4 GB
Author Jeff Shoaf
Thanks Aage. I have an automated backup running every night and had the
same problem with backups made on two consecutive nights - and the
failure happened at the same place with both backups.

I'll try another backup Monday when I get back to work and see what
happens.

aagjohan@... (Aage Johansen) wrote in
news:4.2.0.58.20030503134621.00a3f0f8@...:

> jeffshoaf wrote:
>
>
> > Done with volume #1, "labels.gbk"
> > Press return to reopen that file, or type a new
> > name followed by return to open a different file.
>
>
> I've seen this (don't remember which version of Fb, but I think it was
> last= =20
> summer).
> I never was able to complete that restore. Other backup files (made
> the=20 same way) were fine, however.
> It was a small database - about 50MB.
>
>
> Later:
> I think I found a copy of the backup that couldn't be restored, and I
> am=20 looking at the contents - it is from June 2002. The first 1/3
> of the file= =20
> seems fine, but after that there is only zeroes.
>
> A hex dump of the backup looks like:
> 007EFF50 11 04 20 00 00 00 02 04 00 00 4F 51 FD 00 06 05 ..
> .......OQ= =FD...
> 007EFF60 42 41 4D 53 45 FA 00 01 0D F4 00 06 01 04 20 00
> BAMSE=FA...=F4= .... .
> 007EFF70 00 00 11 04 1C 00 00 00 02 04 00 00 4F 51 FD 00
> ............OQ= =FD.
> 007EFF80 05 04 48 41 4E 4E FD 00 01 0D F4 00 06 01 04 1C
> ..HANN=FD...= =F4.....
> 007EFF90 00 00 00 11 04 20 00 00 00 02 04 00 00 4F 51 FD .....
> .......O= Q=FD
> 007EFFA0 00 09 08 46 2E 31 33 30 37 30 30 FD 00 01 0D F4
> ...F.130700=FD= ...=F4
> 007EFFB0 00 06 01 04 20 00 00 00 11 04 20 00 00 00 02 04 ....
> ..... ...= ..
> 007EFFC0 00 00 4F 51 FD 00 06 05 59 52 56 49 4E FA 00 01
> ..OQ=FD...YRVI= N=FA..
> 007EFFD0 0D F4 00 06 01 04 20 00 00 00 11 04 1C 00 00 00 .=F4....
> .....= ....
> 007EFFE0 02 04 00 00 4F 51 FD 00 03 02 46 2E FB 00 01 0D
> ....OQ=FD...F.= =FB...
> 007EFFF0 F4 00 06 01 04 1C 00 00 00 11 04 20 00 00 00 02
> =F4.......... = ....
> 007F0000 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
> ..............= ..
> 007F0010 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
> ..............= ..
> and so on ...
>
> I guess this is from this table
> CREATE TABLE XVETBASE (
> VERDI VARCHAR( 16 ) NOT NULL primary key,
> FELT SMALLINT NOT NULL,
> ID INTEGER NOT NULL,
> CONSTRAINT INTEG_26 PRIMARY KEY ( VERDI, FELT, ID)
> )
>
>
> --
> Aage J.
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~--> Rent DVDs from home.
> Over 14,500 titles. Free Shipping
> & No Late Fees. Try Netflix for FREE!
> http://us.click.yahoo.com/BVVfoB/hP.FAA/uetFAA/67folB/TM
> ---------------------------------------------------------------------
~-
> >
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
> =20
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/=20
>
>
>