Filegroup

All data files in a filegroup should be the same size. ❋ Unknown (2009)

Essentially, a filegroup is a construct to provide a logical storage location for an object when it is created. ❋ Unknown (2008)

Backing up a filegroup is a shortcut to backing up all the files it contains. ❋ Unknown (2008)

As soon as all the files in a filegroup are full, the Database Engine automatically expands one file at a time in a round-robin manner to allow for more data, provided that the database is set to grow automatically. ❋ Harsh Chawla (2011)

For example, a filegroup is made up of three files, all set to automatically grow. ❋ Harsh Chawla (2011)

When space in all the files in the filegroup is exhausted, only the first file is expanded. ❋ Harsh Chawla (2011)

As data is written to the filegroup, the SQL Server Database Engine writes an amount proportional to the free space in the file to each file within the filegroup, instead of writing all the data to the first file until full. ❋ Harsh Chawla (2011)

You talk about copying the contents out of one file and putting them into another file -- i'm assuming you are meaning a new FileGroup and moving the objects into a new filegroup to transfer all the data to the new filegroup. [[rdorr]] Yes a new file in the same file group or a new file group. ❋ Psssql (2011)

When the first file is full and no more data can be written to the filegroup, the second file is expanded. ❋ Harsh Chawla (2011)

The question I have there is that if it is the filegroup that contains the system objects for the database, how do we get that information over into the new file? ❋ Psssql (2011)

Is the problem only encountered during growths? if so, should we disable growth until we can reset the file attribute or move the contents somehow to another filegroup? ❋ Psssql (2011)

When the second file is full and no more data can be written to the filegroup, the third file is expanded. ❋ Harsh Chawla (2011)

If the third file becomes full and no more data can be written to the filegroup, the first file is expanded again, and so on. ❋ Harsh Chawla (2011)

Filegroups use a proportional fill strategy across all the files within each filegroup. ❋ Harsh Chawla (2011)