SAP Knowledge Base Article - Preview

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

Symptom

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
labels)
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."


Read more...

Environment

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

Product

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

Keywords

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.