Up until recently, IQ supported only data backup and restore. So if you had a disk, or other catastrophic failure, and you needed to restore your IQ database, you would have to turn back the clock to the last time you backed up the database. All those committed transactions that occurred after the backup was done would be lost.
But as anyone competing in the marketplace nowadays knows, lost data (and lost information,) can greatly affect the performance of your business.
Simply put: every transaction matters.
With this in mind comes IQ SP08 and support for Point-in-Time Recovery. With PITR, you can now choose to backup the IQ transaction log as well as the data. Then, if you need to restore the database, you can restore the data backup, and also restore all committed transactions after the data backup to a point in time of your choosing. And the best part is, you can do this with both IQ Simplex and Multiplex (SP08 PL1. release) configurations.
As an IQ customer, this helps bring you more continuous operations in the face of disaster, and most importantly, peace of mind.
Now you may be thinking, this is great ( ! ) but how do I learn more about this capability and use it in my IQ implementation?
To help you get started, we’ve created a simple cookbook that shows you how to set everything up and validate the correct operation. Just click on the link below to access it 🙂
We hope this post helps you see how you can incorporate this integral IQ SP08 feature into your Disaster Recovery strategy, and what a big difference it will make!
Thoughts? Questions? Or is there another IQ feature you’d like us to blog about? Let us know in the comments or send me an e-mail! 🙂
Maria Stoianova | SAP Sybase IQ Product Management | Email: email@example.com