Post reply

Creating a new File Group, and movinf existing tables to it....

  • May 7, 2004 at 11:21 am

    #87141

    Our current set up is that all tables reside on one File Group.

    I would like to create a new File Group, and move some of the existing tables on to that File Group. What is the best way to do this?

    Would creating the new File Group, hiving data from current tables into temp tables. Script the table, and re create on new file group - populate with data from temp table work?

    Can someone suggest a better alternative?

     

    Thanks in advance.

  • May 10, 2004 at 8:00 am

    This was removed by the editor as SPAM

  • May 10, 2004 at 1:10 pm

    #505863

    Probably the easiest way to achieve this is to recreate the clustered index on this new filegroup. If you don't have a clustered index, you can still use this technique, just drop the clustered index after your operation.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

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

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