SAP IQ - Transaction Log Restore / Backup

[kairi2210]

Hello Experts,
We just finished install SAP IQ , everything goes well.
And now we are trying to do some testing on backup/restore of our transaction log

(backup/restore of catalog went well)

For restoration of transaction log, we did dblog -t new.log iq.db (To be honest we are not sure is this the correct way to backup/restore translog)

In summary , this is how our plan on doing this.
Backup Test
At first we make a full backup
We add user1

Backup the transaction log#1 using dblog -t

We add user2

Once again backup the transaction log#2

Restore Test

We restored from the full backup

- Check existence of user1 and user2, should not be existed

Restore transaction log #1 and transaction log#2 to check the existence of user1,user2
Here is the problem, when we started to use the old log, we could not restore it. But when use the new translog, there is no problem starting the server/db.

My questions

1. Is this the right way to test the transaction log backup/restore

2. Is this the right way to restore the old translog? If not, is there any other ways on doing so?

[RobertWaywell · Accepted solution]

When you run dblog -t <file name> the dblog utility changes the name of the transaction log, it does not create a backup copy of a transaction log. Since that command doesn't delete or overwrite the old transaction log, I can see how it might look like a 'backup' but it really isn't.

The backup utility for SAP IQ is dbbackup: dbbackup Database Administration Utility Running "dbbackup -t" will create a backup of the log file only as described:

• -t

  Backs up only the transaction log file. This can be used as an incremental backup since the transaction log can be applied to the most recently backed up copy of the database files.

[kairi2210 · Accepted solution]

Hello Robert,
Thank you so much for your replies.

Actually this is my first time working with sql db, i am not that familiar with the command.
I tried to do as the website does, but it seems that i need to fill in the user id/password. do you mind telling me how do i put the id/pass in the command? Im using DBA for the test datbase user.

[kairi2210 · Accepted solution]

UPDATED
I've managed to take the backup.
Just a question, can i use dblog to restore the backup?

[RolandKramer]

Hello kairi2210

In fact you can use the event based IQ Backup not only for Transactional Log Backup, as it is used as SAP NLS and ILM preferred backup method.

See the Document - SAP First Guidance – SAP NLS Solution with SAP IQ 16.x

Also referring to you other question - SAP IQ transaction log - To mirror or not to mirror?

Best Regards Roland

[kairi2210]

Thank you Roland, i am now reading the document 🙂