Post reply

Moving tables to another FileGroup

  • September 17, 2002 at 8:32 am

    #58032

    I will be moving tables on to another FileGroup. I looked at the ALTER TABLE command for an easy method and did not find one. Is there a quick and easy way to do this?

    I am going to try and avoid recreating the tables if I have to. To the best of my knowledge this is the only way to do it so I am seeking others advice on the situation..

    Thanks 🙂

    Jeff Weisbecker


    "Keep Your Stick On the Ice" ..Red Green

  • September 17, 2002 at 8:39 am

    #436664

    Drop your clustered index, and then re-build it on a new filegroup. If you don't have a clustered index, then create one on the new filegroup. When you create the clustered index, it will build the index, and move the data to the new filegroup.

    Gregory Larsen, DBA

    If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

    Gregory A. Larsen, MVP

  • September 17, 2002 at 6:43 pm

    #436729

    The easiest way to change the filegroup of a table is through Enterprise Manager, in the design of the table, change the filegrop by clicking the new filegroup from a drop-down list.

    first you need to create the new filegroup.

  • September 18, 2002 at 2:54 pm

    #436808

    Thanks!!

    I never knew I could do that through 'Design Table', but I found it 🙂

    fyi-I traced the execution through profiler and found that it dropped the table and recreated it.


    "Keep Your Stick On the Ice" ..Red Green

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

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