SAP Knowledge Base Article - Preview

2793868 - RESTORE DATABASE using network file on Windows fails with ‘Unknown err status reading HDR labels’ error - SAP IQ


When executing RESTORE DATABASE command like below to restore IQ database using backup file stored on a network drive, it fails with error:

restore database 'C:\ProgramData\SybaseIQ\demo\iqdemo.db' from '\\\\hostname\\test\\test.bak'

Could not execute statement.
Error during backup/restore: unable to open device
\\\\hostname\\test\\test.bak (Unknown err status reading HDR
SQLCODE=-697, ODBC 3 State="HY000"
Line 1, column 1

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."



  • SAP IQ 16.1
  • SAP IQ 16.0
  • SAP IQ 15.4
  • Microsoft Windows


SAP IQ 16.0 ; SAP IQ 16.1 ; SAP Sybase IQ 15.4


SQLCODE, 697, net, drive, archive, device , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , Problem

About this page

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

Search for additional results

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