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 for Me (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.