IQ Virtual Backup to Amazon S3 with the Click of a Button
One common complaint customers have when performing backups of a large database, is the amount of physical storage required to store the backup. But what if it was possible to back up your IQ database directly to the cloud, eliminating the need to reserve expensive storage on site for the backup files?
Using S3Sync and Interactive SQL, it is truly easy to wrap the process of backing up an IQ database to Amazon S3 into an executable batch file and to wrap the restore process in a separate batch file. Detailed instructions for how to accomplish this can be found at the end of this post.
S3Sync is third party software used for uploading and downloading files to and from S3 via the command line. The software provides flexible options that make S3 uploads and downloads easy and personalized. (https://sprightlysoft.com/S3Sync/)
IQ is packaged with a Virtual Backup feature, allowing the user to employ third party command line tools within the context of an IQ backup operation to copy the IQ user data files to an alternate location. IQ does not manage this portion of the operation, but ensures that the backup of the IQ catalog and the user data are consistent. The Virtual Backup feature provides ultimate flexibility when performing and storing backups.
Combining the virtual backup command with a utility to upload backed up files to the cloud provides a simple, one-stop solution for IQ database backups. The link below is an example and tutorial regarding this batch file pair: virtual backup and upload to S3 as well as the corresponding IQ database restore.