How to: Merge Partitions

  • Article

You merge partitions in SQL Server Management Studio. In order for partitions to be merged successfully,both partitions must have the same aggregation design, and they must be in a processed state. For more information about partition processing, see Processing Analysis Services Objects.

To merge partitions

  1. In Object Explorer, expand the Measure Groups node of the cube containing the partitions that you want to merge, expand Partitions, right-click the partition, and then click Merge Partitions.

    The Merge Partition <partition name> dialog opens.

  2. Under Source Partitions, select the check box next to each source partition that you want to merge with the target partition, and click OK.