Thursday, July 19, 2012 4:25 AM
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?
Thursday, July 19, 2012 9:04 AM
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.
Friday, July 20, 2012 2:57 AM
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?