SAP Knowledge Base Article - Preview

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


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"

  RESTORE DATABASE '/work/dbs/161res/161spx_res.db'

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



SAP IQ 16.1 SP 02


SAP IQ 16.1


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.