Skip to Content
avatar image
Former Member

IQ Upgrade 16.0 SP11 to 16.1 SP2 results in 50MB backups (were 1.7GB before upgrade)??

Hi all,

I have upgraded a demo IQ 16.0 SP11 to 16.1 SP02.

Before the upgrade the IQ database backups were consistent in size @ 1.7GB

Since the upgrade to 16.1 SP02 the backups are now 50MB. I am perplexed as to why this is.

Has anyone encountered this issue? If so do you know what the fix is please?

Below is my backup cmd:

BACKUP DATABASE to '/share/backup/IQD_060318.bkp'

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 06 at 01:46 PM

    What are related outputs from

    sp_iqbackupsummary ;

    sp_iqbackupdetails '<backup_id>';

    sp_iqdbsize;

    Has backup completed successfully? Track #blocks copied info from iqmsg file.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 07 at 06:19 AM

    Hi Tayeb.

    Thanks - your commands were very helpful. I used:

    sp_iqbackupdetails '<backup_id>';

    select * from sysiqbackuphistory - in order to <get backup_id>

    It turned out that the IQ_SYSTEM_MAIN dbspace (4 files @ 2GB in size each) which was backing up 1.6GB with 16.0 SP11 before...though now it only backs up approx 26MB (files being same size as before) since it has been patched to 16.1 (so the new version must not be backing up empty space).

    Add comment
    10|10000 characters needed characters exceeded