Thank you very much for your answer Helen. I do backups every day, one full and several incrementals. Well, rather it is done automatically by my program.
I understand that each commited (and not commited, of course) row keeps the number of its TID, so that number is always present in the row. When after a cycle backup/restore the Next Transaction is 1 because all the integer numbers were used, what happens? that database cannot be used anymore for inserts, updates and deletes? Greetings. Walter. On Sun, Sep 8, 2013 at 7:11 PM, Helen Borrie <[email protected]> wrote: > ** > > > At 10:03 a.m. 9/09/2013, W O wrote: > > >Thank you very much for your answer Sean. > > > >Then, I am understanding bad or a database just can have a maximum of > 2.147.483.547 commited transactions? > > You understand correctly. When the TID is approaching the 2-billion mark > you'd better start thinking about backup and restore if you've never > thought it necessary before! > > Helen Borrie, Support Consultant, IBPhoenix (Pacific) > Author of "The Firebird Book" and "The Firebird Book Second Edition" > http://www.firebird-books.net > __________________________________________________________ > > >
