I cant reduce PRIMARY filegroup size even when empty

• Dean Jones-454305

  SSCarpal Tunnel

  Points: 4804

  More actions

  April 16, 2008 at 8:47 am

  #123440

  Hi All,

  I am trying to reduce the size of my database and noticed that the primary filegroup is taking almost 120GB, even though it has no objects on it apart from the normal system tables.

  I am not sure if system tables can take up to 120GB, If i try to shink the file and empty it, the file never goes below the 120GB size and IF i run dbcc shrinkfile(1,emptyfile)

  I get the error

  Msg 2556, Level 16, State 1, Line 1

  There is insufficient space in the filegroup to complete the emptyfile operation.

  Can anyone help here

• VaibhavChoubey@SQL

  Ten Centuries

  Points: 1033

  More actions

  April 24, 2008 at 1:47 pm

  #806870

  I am not sure that you can use EmptyFile option on Primary filegroup.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736270

  More actions

  April 24, 2008 at 1:56 pm

  #806880

  I don't think you can reduce the size below it's initial size.

  You can move the data by moving the clustered index if there are tables in there.