Symptom
- When enabling and using Point In Time Recovery, command "RESTORE .. Recover until Timestamp" fails with error :
Catalog restore complete
IQ file pre-allocation complete
IQ data restore complete
Could not execute statement.
Unable to start specified database: Attempt to start recovery before
first checkpoint of the backup
SQLCODE=-82, ODBC 3 State="08001"
Line 1, column 1
- Messages below can be seen In utility server srvlog,
I. 04/10 15:53:29. Starting database "a_restore" (C:\Users\TEST\myiqdb\repro.db) at Fri Apr 10 2015 15:53
I. 04/10 15:53:29. Performance warning: Database file "C:\Users\TEST\myiqdb\repro.db" consists of 90 disk fragments
I. 04/10 15:53:32. Starting database "a_restore" (C:\Users\TEST\myiqdb\repro.db) at Fri Apr 10 2015 15:53
E. 04/10 15:53:32. Error: Database cannot be started -- Attempt to start recovery before first checkpoint of the backup
Read more...
Environment
SAP IQ 16
Product
Keywords
pit , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed
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.
SAP Knowledge Base Article - Preview