Symptom
Restore incremental backup failed with error message:
"Database has changed since last restore"
In iqmsg file:
I. 09/29 09:28:30. 0000000005 ValidateRestore_2
I. 09/29 09:28:30. 0000000005 Exception Thrown from dblib\db_backupID.cxx:682, Err# 195, tid 25 origtid 25
I. 09/29 09:28:30. 0000000005 O/S Err#: 0, ErrID: 4098 (db_sqlexception); SQLCode: -1012008, SQLState: 'QUA08', Severity: 14
I. 09/29 09:28:30. 0000000005 [20931]: Database has changed since last restore.
In utility server srvlog:
I. 09/09 16:20:19. Starting database "a_restore" (c:\usr\sap\BX2\SAPIQ\database\SAPIQ.db) at Fri Sep 09 2016 16:20
I. 09/09 16:20:19. Performance warning: Database file "c:\usr\sap\BX2\SAPIQ\database\SAPIQ.db" consists of 120 disk fragments
E. 09/09 16:20:51. Error: Modifications of the iq main store not allowed in readonly mode.
-- (stcxtlib\st_database.cxx 5503)
Read more...
Environment
SAP Sybase IQ
Product
Keywords
sybase, restore, incremental, iqro, -1012008, readonly , 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.