2652342 - PITR restore to different location results in 'unable to open database file ....' - SAP IQ

Symptom

Executing restore of Point In Time Recovery (PITR) backup to a different location could result in the following error:

/work/dbs/161res> dbisql -c "uid=dba;pwd=sql123;eng=util;dbn=utility_db" res.sql
Max recoverable offset: 0
Could not execute statement.
Backup is unable to open database file '/work/dbs/161spx/iqdemo.log'
SQLCODE=-1079, ODBC 3 State="HY000"

/work/dbs/161res/res.sql:1
RESTORE DATABASE '/work/dbs/161res/161spx_res.db'

Note: Restore command is trying to open Source server's transaction log and returning an error.

Environment

SAP IQ 16.1 SP 02

Product

SAP IQ 16.1

Keywords

sybase ; pitr ; PointInTimeRecovery ; recovery ; , KBA , BC-SYB-IQ , Sybase IQ , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.