Did some changes on a big table:
- table partitioning,
- increased pctfree,
- new cluster index

to get better performance (especially insert performance). Now I anticipated the extra disk occupation caused by the empty blocks configured with pctfree, but now I see that the backup-image is also significant larger.
Empty blocks are not included in the backup, are they?

(v9.5.5 on win2003)

Hi,

empty blocks are not included in the backup. But pctfree is the free space which will be left free in every block (for later inserts). So increasing pctfree also increases the size of your table and your backup.