Subject | Re: [IB-Architect] Backups of large database & super transactions |
---|---|
Author | Marco Lauria |
Post date | 2000-06-16T23:10:56Z |
At 11.36 16/06/2000 -0700, you wrote:
You make a full backup
and then you can make some logical backups containing the various
modifications
made to the database.
King Regards,
Marco Lauria
>I agree I saw a similar login in INFORMIX.
>Some time I suggested implementing the ability to create named freeze points
>in the database. This essentially would be a super transaction. There are
>various benefits of having super transactions and backups could take full
>advantage of them as well.
>
>Thus, a DBA would have the option to declare a freeze point in the database
>and perform a backup for that freeze point. Then, for the next week on a
>daily basis a backup could be performed only sending to the backup file that
>which has changed since a certain freeze point. This would allow a much more
>refined backup strategy.
>
You make a full backup
and then you can make some logical backups containing the various
modifications
made to the database.
King Regards,
Marco Lauria