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 pageThis 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.