Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2006
    Location
    DC
    Posts
    123

    Unanswered: Files & FileGroups

    Hey guys I have a VLDB and I would like to point or move several tables to another filegroup.

    1). Add a filegroup to the database
    ALTER DATABASE dbname
    ADD FILEGROUP filename_table
    go

    2). Add a file to the file group
    ALTER DATABASE dbname
    ADD FILE
    .....
    TO FILEGROUP filename_table
    go

    If a table is already part of the primary filegroup:
    Can I change it to another filegroup?
    When changed to the another filegroup will it move the whole table to the other filegroup or just start to write data to the newly created filegroup?

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    In order to move the table to another filegroup, you need to first move the data, then move any indexes that you also want on that filegroup or another filegroup. To move the data, you need to create or alter the clustered index. To move the indicies, you need to drop and recreate the indicies.

    -PatP

  3. #3
    Join Date
    Jun 2006
    Location
    DC
    Posts
    123
    thanks Pat for the heads up I will work towards that....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •