Skip to Content
avatar image
Former Member

How to get Completion time for Syabse IQ BACkup

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 ...

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 24 at 01:50 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 01 at 06:56 PM

    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

    Add comment
    10|10000 characters needed characters exceeded