> If your generators are at the start of the database file and the copying > takes a while (large db), and there are a lot of concurrent transaction > then the state of the generator page at the time that page was copied is > not the same as at the time the last page of the database file is copied.
In a test blank database, the first generator page is at 148 (See Firebird Internals http://www.firebirdsql.org/file/documentation/reference_manuals/reference_material/html/fbint-page-9.html). So the generator page is pretty close to the beginning of the database file. On a large database at least. There will be other generator pages if there are more than 508 generators. The above is on a 4K database page size. Cheers, Norm. -- Norman Dunbar Dunbar IT Consultants Ltd Registered address: Thorpe House 61 Richardshaw Lane Pudsey West Yorkshire United Kingdom LS28 7EL Company Number: 05132767
