2163362 - Attempt to start recovery before first checkpoint of the backup - SAP IQ | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2163362 - Attempt to start recovery before first checkpoint of the backup - SAP IQ

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

SAP IQ 16.0

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 ONE Support launchpad (Login required).

Search for additional results

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