Skip to Content
0

How to get Completion time for Syabse IQ BACkup

Jan 22 at 10:33 PM

45

avatar image
Former Member

Below table /proc provide only start time but no info when backup was completed .

Table :SYSIQBACKUPHISTORY

store sp_iqbackupdetails

I know we can find from msq file .. wanted to check any system table/proc can give this info ...

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Harpreet Chaudhary
Jan 24 at 01:50 PM
0

Hi Ajay,

No, the backup completion time information is not stored in any system table.
Only way to get it would be to extract it from .iqmsg .

Regards
Harpreet

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 01 at 06:56 PM
0

Hi Ajay,

You can find the last completed backup time in sp_iqstatus.

Last Full Backup ID:6663248

Last Full Backup Time:2016-12-06 11:09:53

Last Backup ID:6663248

Last Backup Type:FULL

Last Backup Time:2016-12-06 11:09:53

Regards,

Santosh Negalur

Share
10 |10000 characters needed characters left characters exceeded