Post reply

Altering Partition Scheme and Function

  • October 27, 2009 at 5:37 pm

    #211466

    Hi Expert,

    I would like to know how will I alter the my partition scheme and function if it has already data on it. :hehe:

  • December 15, 2009 at 6:58 am

    #1092484

    I am also having issues with modifying partition schemes using existing data.

    Here's what I have done:

    1. Created filegroup and added files

    2. ALTER PARTITION SCHEME partition_scheme_name NEXT USED filegroup_name

    3. ALTER PARTITION FUNCTION partition_function_name SPLIT RANGE (value).

    What happened is that SQL Server moved the existing data from one filegroup to another. When I look at the partition scheme it does not appear that the new filegroup is included.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply