Post reply

Moving data between filegroups

  • June 28, 2011 at 12:34 am

    #240484

    I need some help in understanding the options that are available in moving data from one filegroup to another.

    As per my knowledge, these are some of the options available

    Option 1: Recreate clustered index on the new filegroup

    Option 2: Create a table on new filegroup, insert data from table in old filegroup, drop the table in old filegroup.

    Are there more options available.

    Actually, can we have a discussion on why we should opt for one option over another?

    M&M

  • June 28, 2011 at 1:48 am

    #1344990

    My vote goes to the first method. It saves you from re-creating every depending object on the table (indexes, keys, defaults, constraints etc...)

    -- Gianluca Sartori

  • June 28, 2011 at 2:32 am

    #1345008

    Thank you Gian, very good point really.

    M&M

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

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