Manage Partition Wizard F1 Help

Use the Manage Partition Wizard to manage and modify existing partitioned tables through partition switching or the implementation of a sliding window scenario. This wizard can ease the management of your partitions and simplify the regular migration of data in and out of your tables.

To start the Manage Partition Wizard

  • In SQL Server Management Studio, select the database, right-click the table on which you want to create partitions, point to Storage, and then click** Manage Partition**.

    Note   If Manage Partition is unavailable, you may have selected a table that does not contain partitions. Click Create Partition on the Storage submenu and use the Create Partition Wizard to create partitions in your table.

For general information about partitions and indexes, see Partitioned Tables and Indexes.

This section provides the information that is required to manage, modify, and implement partitions using the Manage Partition Wizard.