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:

• In the Filename(s) table, indicate where the backup is to be stored by entering one or more filenames. To insert a new row into the Filename(s) table, move to the last row and column in the table and type W‑Z. When entering a filename, make sure to include the file path unless you wish to write the file to the current working directory.
• The Size (Pages) field is optional and denotes the size of the file in units of pages, using the page size of the database. If the [size] parameter is not provided, then the size of that dump file will be determined by its file-sequenced counterpart in the database. If the sequence of the dump file is higher than the sequence of any database file, then it takes the size of its predecessor dump file.

4. 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.

5. Choose OK to start the backup.