I have an issue with restoring SAP IQ 16 on a simple Windows install. Its the IQDEMO database so couldn't be more simple. The database files are in E:\IQDEMO and backups to D:\IQDEMO_backup. Here is the workflow ...
--logon on to IQDEMO database via dbisql as 'dba'
BACKUP DATABASE FULL TO 'D:\\IQDEMO_backup\iqdemobakfull' with comment 'full'
--The file ... D:\IQDEMO_backup\iqdemobakfull.1 ... gets created
--Stop IQDEMO service
--Delete the .iq .db and .log files in database location E:/IQDEMO
--Start utility database
--logon on to utility database via dbisql as 'dba'
RESTORE DATABASE 'iqdemo' FROM 'D:\\IQDEMO_backup\iqdemobakfull'
--following error generated
Could not execute statement.
.db or .log file exists.Full restore will not be done.
SQLCODE=-1012025, ODBC 3 State="HY000"
Line 1, column 1
The actual IQ files are in E:/IQDEMO with the backups going to D:\IQDEMO_backup.
I've deleted the .iq .db and .log files in E:/IQDEMO before attempting restore.A
Sure I'm doing something dumb.