consolidating data files

• mgraulich

  Ten Centuries

  Points: 1294

  More actions

  March 17, 2006 at 11:05 am

  #112390

  Say I have a filegroup called TEST and under test I have three files attached

  test_data/test_data1/test_data2.

   

  Is there a way to consolidate those three files into one?

• Ray M

  SSC-Insane

  Points: 21093

  More actions

  March 17, 2006 at 11:18 am

  #627421

  The way I can think of

  is create a new filegroup, and a new file.

  then move all objects from old filegroup to new one. Drop the old one.