Incremental Backup

Database
Enthusiast

Incremental Backup

Hi,

I want to take the incremental backup of the database/tables and restore them back.What all things I should do to achieve the same? Please explain in detail.

Thanks,

Terankit

1 REPLY
Enthusiast

Re: Incremental Backup

Incremental backups are used with permanent journals. You need to enable journalling. These journals keep a snapshot of all the changes that have taken place since the last backup and while backing up, you just back up these journals rather than backing up the complete table or database.

The frequency for these backups can vary however a common practice is to have a daily incremental backup (journal only) and a weekly full backup (may be on weekends)

Refer to the documenation for more detail on journalling.

Regards...