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
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 pageThis 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.