yes, i meant small backups like differential backup from previous backup. On Sat, Sep 16, 2017 at 6:24 PM, Peter Ondruška <peter.ondru...@kaibo.eu> wrote:
> Depends what you mean by incremental. Should you want to minimize data > created by backup (and increase time to recover) enable log arching and > protect full database backup and log files created after that. There is no > such thing as backing up "incrementally" i.e. only those blocks that > changed since last backup. > > I would recommend running with log archiving anyway and doing online > backup (SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE) > frequently enough (daily) avoiding applying many log files for recovery. > > See https://db.apache.org/derby/docs/10.0/manuals/admin/hubprnt46.html > and documentation on the procedures used in that page. > > p. > > On 16 September 2017 at 14:32, Shreyans Jain <shreyans2...@gmail.com> > wrote: > >> Is it possible in any way (may be a workaround or hack) to do online >> incremental backup of anything (logs, data files etc) by which database can >> be restored using that backup. >> >> Regards, >> Shreyans Jain >> > > > > -- > Peter Ondruška > > kaibo, s.r.o., ID 28435036, registered with the commercial register > administered by the Municipal Court in Prague, section C, insert 141269. > Registered office and postal address: kaibo, s.r.o., Kališnická 379/10, > Prague 3, 130 00, Czech Republic > <https://maps.google.com/?q=Kali%C5%A1nick%C3%A1+379/10,+Prague+3,+130+00,+Czech+Republic&entry=gmail&source=g> > . > https://www.kaibo.eu >