REMOVE SECODARY FILE GROUP

• gandalf_03_75

  SSC Rookie

  Points: 35

  More actions

  October 4, 2016 at 1:36 am

  #317995

  Hi all

  I've created a new filegroup on my db and I've also provided to create indexes.

  Now I'm trying to delete the filegroup after drop all interested indexes but I'm unable to do that because even if the indexes are dropped when I execute the below query I found unexpected rows

  SELECT T.NAME AS TABLE_NAME,

  I.NAME AS INDEX_NAME,

  DS.NAME AS DATA_SPACE_NAME,

  DS.TYPE_DESC,

  PS.NAME AS PARTITION_SCHEME_NAME

  FROM SYS.TABLES T

  JOIN SYS.INDEXES I ON T.OBJECT_ID = I.OBJECT_ID

  JOIN SYS.DATA_SPACES DS ON I.DATA_SPACE_ID = DS.DATA_SPACE_ID

  LEFT JOIN SYS.PARTITION_SCHEMES PS ON PS.DATA_SPACE_ID = DS.DATA_SPACE_ID

  WHERE DS.NAME = 'FILEGROUPNAME'

  TABLE_NAMEINDEX_NAMEDATA_SPACE_NAMETYPE_DESCPARTITION_SCHEME_NAME

  TABLE_NAME_1NULL TEST ROWS_FILEGROUPNULL

  TABLE_NAME_2NULL TEST ROWS_FILEGROUPNULL

  TABLE_NAME_3NULL TEST ROWS_FILEGROUPNULL

  TABLE_NAME_4NULL TEST ROWS_FILEGROUPNULL

  TABLE_NAME_5NULL TEST ROWS_FILEGROUPNULL

  Someone could help me to understand where is my mistake?

  Thanks & Regards

  Gan

• linshi07

  SSC Rookie

  Points: 33

  More actions

  October 4, 2016 at 11:55 am

  #1904714

  Maybe this link is helpful:

  http://dba.stackexchange.com/questions/136109/how-to-remove-secondary-file-group