cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Sybase IQ Restoration - Restart utility DB

SAPSupport
Employee
Employee
0 Kudos
269
Hi SAP Support,
Could you please help validate if there will be an impact should we perform a server reboot after restoring full DB backup in a Sybase IQ DB? This requires stopping the utility DB but we will still eventually restore incremental backup files after the reboot. This will be the sequence:
 1 - Restore full DB backup files
 2 - Stop utility DB
 3 - Restart server
 4 - Start utility DB
 5 - Restore incremental backup files
 6 - Start DB

Unfortunately, this scenario cannot be tested since restoration requires more than 32 hours and we have a scheduled cutover this coming weekend. To summarize, could you please confirm if there will be an impact on item 5 (Restore incremental backup files) if we will perform item 2 (Stop utility DB)?
 
Best regards...(truncated)
------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

Accepted Solutions (1)

Accepted Solutions (1)

SAPSupport
Employee
Employee

You may restart OS/utility DB between an IQ full restore and an INCR/INSF restore unless you start up an IQ database after an IQ full restore.

Please refer to KBA 3552044 which has been created for your issue.

--3552044 - SAP IQ - Can OS/utility DB restart between an IQ full restore and an INCR/INSF restore ?
https://me.sap.com/notes/3552044

Answers (0)