Skip to Content
0

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

Mar 06 at 01:32 PM

33

avatar image
Former Member

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'

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

2 Answers

Tayeb Hadjou
Mar 06 at 01:46 PM
1

What are related outputs from

sp_iqbackupsummary ;

sp_iqbackupdetails '<backup_id>';

sp_iqdbsize;

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Mar 07 at 06:19 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded