Subject Re: why the data pages did increase after a backup-restore?
Author emb_blaster
>
> page size for both?
> Alan
>

Hi Alan,

I did not changed it. Like I said, I did a diff in gstat -h with the two databases. But now that you asked, I double checked it. you can see below it. Thanks.

*****before backup-restore *******
Database "estoque2.fdb"
Database header page information:
Flags 0
Checksum 12345
Generation 10854874
Page size 4096
ODS version 11.0
Oldest transaction 10852358
Oldest active 10854723
Oldest snapshot 10854723
Next transaction 10854726
Bumped transaction 1
Sequence number 0
Next attachment ID 31
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Apr 20, 2009 9:23:08
Attributes force write

Variable header data:
Sweep interval: 20000
*END*

*****after backup-restore *******
Database "estoque2X.fdb"
Database header page information:
Flags 0
Checksum 12345
Generation 92
Page size 4096
ODS version 11.0
Oldest transaction 1
Oldest active 2
Oldest snapshot 2
Next transaction 86
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Dec 16, 2009 17:24:05
Attributes force write

Variable header data:
Sweep interval: 20000
*END*