What factor impact to backup OLAP cube size?

Question

Hi all,

I am investigating a strange problem with backup cube size as below:

I have old cube for June and new cube for July, the data increase not too much but the backup cube size (*.abf file) increase alot.

In June cube,The data store in "E:\SQLServer\OLAP\Data\Cube_June.0.db" is 169MB. Backup file size of Cube_June.abf: 79MB

In July cube,The data store in "E:\SQLServer\OLAP\Data\Cube_July.0.db" is 273MB. Backup file size of Cube_July.abf: 237MB

There is around 104Mb data increase is find, but the backup cube size increase alot ( from 79Mb to 237MB).

There fore, What I concern is What factor impact to cube backup size?

Thanks,

Answer 1

Hi,

It sounds like the July backup was not completed with the compression option switched on. I have a very small test cube of 20MB if I back it up without compression the backup is 21MB with compression during the backup the size drops to 10MB.

---

Sean Massey | Consultant, iUNITE

Feel free to contact me through My Blog, Twitter or Hire Me.
Please click the Mark as Answer or Vote As Helpful button if a post solves your problem or is helpful!

Answer 2

Thanks for your reply,

But I backup 2 cube with the same option and the "Apply Compression" is ON.

The "Aggregation Design" still the same in both cube.

It looks strange?