Encapsulated virtual backups

For the system-level backup of table data to be consistent with the virtual backup without additional steps, the system-level backup must be made during the backup command and by the backup transaction. The parameter VIRTUAL ENCAPSULATED 'shell-command' allows arbitrary shell commands to be executed as part of the backup operation to guarantee these semantics. If the shell commands return a non-zero status, the backup operation returns an error. The user must guarantee that the shell commands correctly perform the system-level backup.

1. Use a SQL statement similar to the following:

   BACKUP DATABASE FULL VIRTUAL ENCAPSULATED
   'dd if=iqdemo.iq of=iqdemo.iq.copy'
   TO 'iqdemo.full'
   

1. Restore the system-level copy of the IQ store.

2. Perform a full IQ restore from the backup file.

3. Start the IQ database.