Microsoft® SQL Server 2008 R2 Unleashed

Creating a Partition Scheme

After you create a partition function, the next step is to associate a partition scheme with the partition function. A partition scheme can be associated with only one partition function, but a partition function can be shared across multiple partition schemes.

The core function of a partition scheme is to map the values defined in the partition function to filegroups. When creating the statement for a partition scheme, you need to keep in mind the following:

• A single filegroup can be used for all partitions, or a separate filegroup can be used for each individual partition.

• Any filegroup referenced in the partition scheme must exist before the partition scheme is created.

• There must be enough filegroups referenced ...