Definitions

from Wiktionary, Creative Commons Attribution/Share-Alike License

  • n. A collection of files that, in some database systems, are managed together as a group

Etymologies

Sorry, no etymologies found.

Examples

  • All data files in a filegroup should be the same size.

    SQLServerCentral.com Articles

  • Backing up a filegroup is a shortcut to backing up all the files it contains.

    Recently Uploaded Slideshows

  • Essentially, a filegroup is a construct to provide a logical storage location for an object when it is created.

    Recently Uploaded Slideshows

  • 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.

    Site Home

  • 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?

    Site Home

  • 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?

    Site Home

  • When the second file is full and no more data can be written to the filegroup, the third file is expanded.

    Site Home

  • 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.

    Site Home

  • Filegroups use a proportional fill strategy across all the files within each filegroup.

    Site Home

  • 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.

    Site Home

Comments

Log in or sign up to get involved in the conversation. It's quick and easy.