SAP Knowledge Base Article - Preview

2596793 - "Invalid dbfile name" while running RESTORE DATABASE - SAP IQ

Symptom

When running a RESTORE of an SAP IQ backup, the following error occurs:

Could not execute statement.
Error during backup/restore: Invalid dbfile name "main_002"
SQLCODE=-697, ODBC 3 State="HY000"
File: "Restore.sql" on line 1, column 1
RESTORE DATABASE 'myiq.db'
from 'backup_file.1'
RENAME IQ_SYSTEM_MAIN TO 'main_001.iq'
RENAME "main_002" TO 'main_002.iq'
RENAME IQ_SYSTEM_TEMP TO 'tmp_001.iqtmp'


Read more...

Environment

  • SAP IQ 16
  • SAP IQ 16.1

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

KBA , BC-SYB-IQ , Sybase IQ , Problem

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.