Moving data between filegroups

• M&M

  SSC-Insane

  Points: 21700

  More actions

  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

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  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

• M&M

  SSC-Insane

  Points: 21700

  More actions

  June 28, 2011 at 2:32 am

  #1345008

  Thank you Gian, very good point really.

  M&M