db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jean T. Anderson" <...@bristowhill.com>
Subject Re: database backup questions
Date Thu, 25 Aug 2005 00:23:09 GMT
Suresh Thalamati wrote:
> Mag Gam wrote:
> 
>> Hello derby-users:
>>
>> My questions are:
>>
>> 1)  Is it possible to do an incremental backup for the
>> derby/cloudscape database?
>> Where I have a master set, and apply the small increments?
> 
> 
> Derby has support for roll-forward recovery, using this mechanism  if 
> you take  backup with log archive log mode enabled, derby keeps all the 
> transaction logs. Using the full backup and the transaction log , one 
> can restore the database to latest state before a failure.
> 
> Currently, I think there is no support for archiving logs to a backup 
> location. So , Transaction logs have to be stored on a fault-tolerant disk.
> 
> Derby admin guide has more info under Rollforward section on this topic:
> http://db.apache.org/derby/docs/10.1/adminguide/
> ... 

Incidently, Suresh wrote an excellent developerWorks article on backup, 
restore, and rollforward recovery for derby:

http://www.ibm.com/developerworks/db2/library/techarticle/dm-0502thalamati/

  -jean

Mime
View raw message