SAP Knowledge Base Article - Preview

2729511 - Restore fails with "dbspace with name or path [name] already exists" - SAP IQ

Symptom

When running a restore with a RENAME clause, you may encounter this error during the restore:

1> restore database 'iqdemo' from 'backup' rename iq_system_msg to 'iqdemo.iqmsg'
go2>
Catalog restore complete
IQ file pre-allocation complete
IQ data restore complete
Msg 13284, Level 15, State 0:
SQL Anywhere Error -1234: Dbspace file with name or path 'iqdemo.iqmsg' already
exists.

You may get this error if you try to start the database:

E. 12/06 11:19:50. iqdemo.db is not a valid database file
I. 12/06 11:19:50. Database server shutdown due to startup error
I. 12/06 11:19:51. Database server stopped at Thu Dec 06 2018 11:19
DBSPAWN ERROR: -84
Specified database is invalid

Read more...

Environment

  • SAP IQ 16
  • SAP IQ 16.1

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

KBA , BC-SYB-IQ , Sybase IQ , 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.