SAP Knowledge Base Article - Preview

3228926 - Incremental backup and load in IQ


  • Loading both full and incremental backups are failing. 
  • Load is asking to remove db files.  However,  the restore is on same server(source and target are same).
  • An example of the error is:
    dbisql -c "uid=DBA;pwd=xxx  ;eng=utility_db;dbn=utility_db" -nogui read restore.sql > restore.sql_out
    Could not execute statement.
      IQ store dbfile /dbdumps/ exists. Restore will not be done.
      -- (dblib/db_backupCmds.cxx 3020)
      SQLCODE=-1012037, ODBC 3 State="HY000"
      RESTORE DATABASE '/dbdumps/iq/data/iq_db/test.db'
    You can continue executing or stop.
    1. Stop
    2. Continue
    Select an option:



SAP IQ 16.1


SAP IQ 16.1


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.