Online Documentation for SQL Manager for SQL server

Creating/editing partition scheme


Use the Partition Scheme tab of Partition Scheme Editor to create/edit a partition scheme and specify its properties.

 

Name

Enter a name for the new partition scheme, or modify the name of the partition scheme being edited.

 

Partition function

Use the drop-down list to select the name of the partition function that will use the partition scheme.

 

Partition Scheme Editor - Editing partition scheme definition

 

 

Filegroups

Partitions created by the partition function are mapped to the filegroups specified in the partition scheme.

Select the filegroup name in the Filegroup drop-down list for each of the intervals specified by the partition function. If PRIMARY is selected, the partition is stored in the primary filegroup.

 

Hint: Filegroups can be created on the Filegroups page of the Database Properties dialog.