Database Backup Dialog

Go Up to IBConsole Dialogs

The backup options are shown on the right side of the Database Backup dialog. You can specify options by entering a value, by clicking the option value and choosing a new value from a drop‑down list of values, or by double-clicking the option value to rotate its value to the next in the list of values.

Format

Option values are Transportable and Non-transportable. To move a database to a machine with an operating system different from the one under which the backup was performed, make sure the Format option is set to Transportable. This option writes data in a generic format, enabling you to move to any machine that supports InterBase.

Important:
Never copy a database from one location to another. Back it up and then restore it to the new location.

Metadata Only

Option values are True and False.

When backing up a database, you can exclude its data, saving only its metadata. You might want to do this to:

Retain a record of the metadata before it is modified.
Create an empty copy of the database. The copy has the same metadata but can be populated with different data.

To back up metadata only, select True for the Metadata Only option.

Tip:
You can also extract a database’s metadata using isql. isql produces a SQL data definition text file that contains the SQL code used to create it. IBConsole backup Metadata Only creates a binary backup file containing only metadata.

This function corresponds to the -metadata option of gbak.

Garbage Collection

Option values are True and False.

By default, IBConsole performs garbage collection during backup. To prevent garbage collection during a backup, set the Garbage Collection option value to False.

Garbage Collection marks space used by old versions of data records as free for reuse. Generally, you want IBConsole to perform garbage collection during backup.

Tip:
Disabling garbage collection during the backup process improves backup performance. If garbage collection is necessary, you can run a separate sweep operation using gfix. In addition, you do not want to perform garbage collection if there is data corruption in old record versions and you want to prevent InterBase from visiting those records during a backup.

This function corresponds to the -garbage_collect option of gbak.

Transactions in Limbo

Option values are Process and Ignore.

To ignore limbo transactions during backup, set the Transactions in Limbo option value to Ignore.

When IBConsole ignores limbo transactions during backup, it ignores all record versions created by any limbo transaction, finds the most recently committed version of a record, and backs up that version.

Limbo transactions are usually caused by the failure of a two-phase commit. They can also exist due to system failure or when a single-database transaction is prepared.

Before backing up a database that contains limbo transactions, it is a good idea to perform transaction recovery, by choosing Database>Maintenance>Transaction Recovery in the Database Maintenance window. Refer to Recovering Transactions for more information.

This function corresponds to the -limbo option of gbak.

Checksums

Note:
For performance reasons, InterBase supports true checksums only for ODS 8 and earlier. For ODS 9 and later, InterBase always generates the string “12345” as the checksum. This maintains compatibility with older versions.

Option values are Process and Ignore.

To ignore checksums during backup, set the Checksums option value to Ignore.

A checksum is a page-by-page analysis of data to verify its integrity. A bad checksum means that a data page has been randomly overwritten; for example, due to a system crash.

Checksum errors indicate data corruption, and InterBase normally prevents you from backing up a database if bad checksums are detected. Examine the data the next time you restore the database.

This function corresponds to the -ignore option of gbak.

Convert to Tables

To convert external files to internal tables, set the Convert to Tables option value to True.

This function corresponds to the -convert option of gbak.

Performing a Full Backup with Verbose Output

Option values are None, To Screen and To File.

To monitor the backup process as it runs, set the Verbose Output option value to To Screen. This option opens a standard text display window to display status messages during the backup. For example:

The standard text display window enables you to search for specific text, save the text to a file, and print the text. For an explanation of how to use the standard text display window, see Text Viewer Window.

This function corresponds to the -verbose option of gbak.

Advance To:

Database Connect