Skip to Content

SAP IQ16 - backup restore

Hi

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.

--

(dblib\db_backupCmds.cxx 2844)

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.

Any ideas?

Cheers

Mike


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Apr 13 at 01:31 PM
    1. Make sure no .db, .log in directory E:\IQDEMO
    2. Specify full path and .db:

    RESTORE DATABASE 'E:\\IQDEMO\\iqdemo.db' FROM 'D:\\IQDEMO_backup\\iqdemobakfull'


    Add comment
    10|10000 characters needed characters exceeded

  • Apr 16 at 12:32 PM

    nice ... full marks!

    Thanks

    Mike

    Add comment
    10|10000 characters needed characters exceeded