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'
2> go
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

"Dbspace file with name or path" ,"already exists" , 'Error -1234', , 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 for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.