Manage Partition Wizard (Progress Page) Select Partition Action Page Manage Partition Wizard (New Job Schedule Page)

Manage Partition Wizard (Select Output Option Page) Manage Partition Wizard (Select Staging Table Options Page) Manage Partition Wizard (Switch Out Page) Manage Partition Wizard (Select Partition Action Page) The following sections provide help on the pages of the Manage Partition Wizard. This section provides the information that is required to manage, modify, and implement partitions using the Manage Partition Wizard. Click Create Partition on the Storage submenu and use the Create Partition Wizard to create partitions in your table.įor general information about partitions and indexes, see Partitioned Tables and Indexes.

Note If Manage Partition is unavailable, you may have selected a table that does not contain partitions. 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. This wizard can ease the management of your partitions and simplify the regular migration of data in and out of your tables. Use the Manage Partition Wizard to manage and modify existing partitioned tables through partition switching or the implementation of a sliding window scenario.

Partition wizard