View Backup and Restore Procedure

The only way for IEE to effectively prevent users from updating data files during backup/recovery processing is to shutdown the database.

This is commonly called a cold backup strategy and will insure that the database remains in a consistent state when it is returned to normal operation

Backup Procedure

To back up the Infobright databases, copy the entire directory containing the Infobright data files. This includes all of the databases defined to the IEE instance as well as the KNFolder (usually the data sub-directory in your Infobright installation directory).

You may also take advantage of incremental backups, since only some of the database files are updated when new data is imported. Be sure to do a full backup occasionally.

Restore Procedure

To restore the Infobright databases from a backup image, just copy the backup image into the data directory (usually the data sub-directory in your Infobright installation directory).

Important:
1. If restoring to the point of an incremental backup, the restore must start with the last full back image followed by each incremental image to the point of intended recovery.
2. An Infobright restore is a full instance restore. Do not attempt to restore individual tables or datbase.
3. The restore must include the KNFolder if it is not within the data directory.
4. Do not manually modify database files or move them from one database to another—this may lead to data corruption and unpredictable results.