Post reply

How to Move Table with Non-Clustered Index?

  • September 22, 2013 at 7:48 am

    #298957

    I am moving tables with clustered and non-clustered indexes to a different filegroup. The clustered index moved the table and data as expected. I tried moving a non-clustered index through Management Studio thinking it would move the table but it didn't. I see the index on the new filegroup but the table/data is still on the primary. I also noticed there is now an empty new table created on the filegroup.

    Can someone explain how to move tables with non-clustered indexes?

  • September 22, 2013 at 8:06 am

    #1652191

    Does the table have a clustered index? The presence or absence of non-clustered indexes is irrelevant when trying to move the table.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • September 22, 2013 at 8:08 am

    #1652192

    This particular table does not have a clustered index.

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

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