Post reply

create file group and move table to file group

  • August 20, 2010 at 12:14 am

    #142508

    hi,

    i have database with many tables.

    now i hi have to create the file group and move the tables to file group.

    I read out "if i will rebuild the clustered index on new file group then it will move the table to new file group."

    Please help me.

  • August 20, 2010 at 12:54 am

    #1209475

    pankaj.kuchaliya (8/20/2010)

    I read out "if i will rebuild the clustered index on new file group then it will move the table to new file group."

    Yes you will take this approach.. if there is a heap table so for migration purposes , you can create a clus index on new filegroup and then drop that index.

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • August 20, 2010 at 1:16 am

    #1209482

    USE ALTER INDEX command with drop_existing and specify the new file group.... You can write a dynamic query and loop ot for all the clustered indexes if you just want to move data and for all indexes if you want to empty this existing filegroup completly.

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

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