Usually, removing partitions from a database partition group is a seldom operation. It may be performed, for example, when a server containing the partitions is removed and commissioned from the configuration, or a partition is not placed optimally and induces performance problems. This is the first step if we want to drop the database partitions from the database.
In this recipe, we will remove partitions 3
and 4
, added before to the NAVDATAGRP
database partition group, and redistribute data on the remaining partitions.
It is highly recommended, before you begin, to drop a partition from a database partition group to perform a full database backup.