Subject | Re: [IB-Architect] Backups of large database & super transactions |
---|---|
Author | Dmitry Kuzmenko |
Post date | 2000-06-22T12:10:55Z |
Hello, Marco!
Marco Lauria wrote:
You MUST periodically backup these buffers.
As for Interbase, incremental backup will stop garbage collection
until new record versions are stored in "small backup".
So, if there will be incremental backup in interbase, I prefer 2 options:
1. without incremental backup (as usual)
2. with incremental backup, where DBA will keep in memory to make small
backups every day or week (depends on performance and record versions amount).
--
Dmitry Kuzmenko, Epsylon Technologies.
Welcome to http://ib.demo.ru/ (1251)
Marco Lauria wrote:
> I agree I saw a similar login in INFORMIX.But, Informix can't continue work if logical log buffers are full.
> You make a full backup
> and then you can make some logical backups containing the various
> modifications
> made to the database.
You MUST periodically backup these buffers.
As for Interbase, incremental backup will stop garbage collection
until new record versions are stored in "small backup".
So, if there will be incremental backup in interbase, I prefer 2 options:
1. without incremental backup (as usual)
2. with incremental backup, where DBA will keep in memory to make small
backups every day or week (depends on performance and record versions amount).
--
Dmitry Kuzmenko, Epsylon Technologies.
Welcome to http://ib.demo.ru/ (1251)