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 for Me (Login required).

Search for additional results

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