Merging filegroups

• balbirsinghsodhi

  SSCrazy Eights

  Points: 9210

  More actions

  December 1, 2009 at 4:43 pm

  #385872

  I have created a partitioned table which has 30 file groups and now I wanted to merge into few filegroups. Let me know the best way to do that.

  for example table is partition on date field and created 30 filegroups for the performance purpose but now I feel that these filegroups are too many.

  I am thinking for keeping the partitioned table as it is but reduced to few filegroups.

  Appreciated for your help.

• parthi-1705

  SSCrazy Eights

  Points: 9277

  More actions

  December 2, 2009 at 12:25 am

  #1086286

  Go to Modify Table

  Go to Properties

  Go to Table Designer

  Go to Regular data space specification Go to file group or Part Choose the File groups which you need to modify

  Thanks
  Parthi