Post reply

Multiple Data Files

  • July 11, 2007 at 2:08 pm

    #177436

    I have a database that is over 200 GBs, and would like to break it up. Currently there is one mdf file. If I add ndf file(s), how can I distribute the current data across the new ndfs?

    Thanks...Nali

  • July 11, 2007 at 2:29 pm

    #718786

    recreate the clustered indexes specifying the "ON [Filegroup]" of the CREATE INDEX statement.


    * Noel

  • July 11, 2007 at 2:52 pm

    #718794

    Ok, so do I need to run an ALTER INDEX on every table separately?

  • July 11, 2007 at 2:58 pm

    #718797

    yup, Well only on the ones you plan to "move"


    * Noel

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

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