Post reply

Filegroup

  • July 1, 2003 at 7:01 am

    #59687

    What happens if the primary filegroup gets full and thats defined as the default filgroup in the datbase. If i add another data filegroup will the data inserted use that space? TIA

  • July 1, 2003 at 2:15 pm

    #463833

    I guess, If your default file group is full, it try to expand the files depends on your auto grow property rather using other file group because its not the default one. But if you create another file in the default file group if will use it. Some one correct me if am wrong

    Shas3

  • July 1, 2003 at 3:46 pm

    #463843

    Shas3 is correct in that if you do add another file to the default fg, then sqlserver will automatically using it. Bad idea to completely fill the primary fg since that points to the location of the schema.

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

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