Next Used Filegroup

Go Up to Available object actions by DBMS

This action builds and submits an ALTER PARTITION SCHEME... NEXT USED statement, letting you alter the designated NEXT USED filegroup for a partition scheme.

Platform Availability

• SQL SVR

To Change a Partition Scheme’s Next Used Filegroup

1. Initiate a Next Used Filegroup action against a partition scheme. For more information, see Initiating an object operation.
2. Use the following table as a guide to understanding and modifying settings in the dialog:

Step	Settings and tasks
Next Used Filegroup	Select the new filegroup from the Filegroup Name dropdown.
Preview	Preview the DDL generated for the operation. For more information, see Preview.

3. Click Execute. For information on the scheduling option, see Scheduling.