How to move table partitions to different file groups

  • Hi Experts,

    Can you please help me in movin my 4 table partitions of a table to 4 different file groups. Right now all the partitions are on Primary file group.

  • First you should check few things before moving a table

    1. You cannot change the data type of the partitioning column once the table is partitioned.

    2. You can move an index to a partition scheme after it has been created.

    3. You cannot use the SWITCH option of ALTER TABLE statement on replicated tables.

    Have a look at quite similar discussion ..

    http://dba.stackexchange.com/questions/16708/moving-large-number-of-tables-to-different-filegroups

    Either you can go for a third party tool for moving table partitions to different file group like Lepide SQL Storage Manager

  • I think the easiest would be to create a new partition function and move the table to that new function. I'm assuming you want to move the whole table which has 4 partitions.

    ---------------------------------------------------------------
    Mike Hahn - MCSomething someday:-)
    Right way to ask for help!!
    http://www.sqlservercentral.com/articles/Best+Practices/61537/
    I post so I can see my avatar :hehe:
    I want a personal webpage 😎
    I want to win the lotto 😀
    I want a gf like Tiffa :w00t: Oh wait I'm married!:-D

  • The above all mentioned operation can also be performed easily by any sql management software in a very few time

    it save lot of time of DBA

    http://www.sqlservermanagement.net/

Viewing 4 posts - 1 through 3 (of 3 total)

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