Post reply

Primary data file still growing when a secondary filegroup exists and checked as default?

  • June 5, 2013 at 9:05 am

    #394914

    I have a 750gb data file that is in the primary filegroup. It is still set to autogrowth 100mb. A secondary data file and filegroup was created and checked as the default. The size is about 112gb.

    Sorry if a stupid question but why is the primary data file still growing when a second data file has been added? I would like to not have the primary file grow any larger. Is that possible?

  • June 5, 2013 at 9:19 am

    #1621376

    Data been added to existing tables that are in the primary filegroup?

    People specifying ON [PRIMARY] when creating tables and indexes?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • June 5, 2013 at 11:42 am

    #1621443

    azenon (6/5/2013)

    I

    Sorry if a stupid question but why is the primary data file still growing when a second data file has been added? I would like to not have the primary file grow any larger. Is that possible?

    Just creating a secondary file group with not automatically move any exiting data from the primary. Unless you make the new file group the DEFAULT file group, or specify that groun usin "ON [filegroup]" any new tables will continue to be created on the old one.

    If you want to move any existing tables to the new file group you can drop and re create the clustered index onto the new file group.

    The probability of survival is inversely proportional to the angle of arrival.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply