Performing an incremental backup using IBConsole

Go Up to Performing backups and restores using IBConsole

An incremental backup copies all of the changes that have been committed to the database since the last full backup. The first time you choose Incremental Backup from IBConsole, InterBase performs a full physical backup (an online dump). After the initial full dump, each subsequent incremental backup saves and copies all of the transactions committed since the last full backup.

To initiate an incremental backup using IBConsole, take the following steps:

1. In the tree pane, right-click the database on which to perform an incremental backup, and select Backup/Restore from the context menu.
2. When the context menu expands to display backup and restore options, select Incremental Backup. The Incremental Backup dialog appears, as shown in the figure:
   
3. On Incremental Backup, specify the following:
   • To add a dump file click on the Files section, on the New Dump File dialog click to set the name and destination folder of your backup, .
   • Once you add a file, the Tablespaces tab shows a list of tablespaces on the database.
   • To change a file location, select a file and click
4. To use multiple files go the Multiple Files tab, select Use Multiple Files and click to add files.
5. To overwrite the previous incremental backup, change the Overwrite value to True. For detailed information about what occurs when you overwrite an incremental backup, see Over-writing Incremental backups.
6. Choose OK to start the backup.

Advance To:

• Restoring a database using IBConsole