Subject Re: [firebird-support] Odd problem - inconsistent result set
Author Milan Babuskov
Vlad Khorsun wrote:
> Make backups daily or more often. No need to
> restore often. Many databases work years without restore.

Confirmed. I have some 4 ODS 10.0 databases in production since 2003.
Never did a restore on them. They are currently running happy with
Firebird 2.0. Here's one I have direct access to:

root@ser0002:~# /opt/firebird/bin/gstat -h /baze/troskovi.gdb

Database "/baze/troskovi.gdb"
Database header page information:
Flags 0
Checksum 12345
Generation 335627
Page size 1024
ODS version 10.0
Oldest transaction 330138
Oldest active 330139
Oldest snapshot 330139
Next transaction 335619
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 19
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Jul 3, 2003 18:17:17
Attributes force write

Variable header data:
Sweep interval: 20000

Milan Babuskov