from Wiktionary, Creative Commons Attribution/Share-Alike License

  • n. Plural form of filegroup.


Sorry, no etymologies found.


  • Examples in many sources, including BOL, label filegroups with no particular meaning (e.g.,

    Recently Uploaded Slideshows

  • Indexes, data, should be on separate filegroups and filegroups should be spread on physical disks.

    Scaling SQL Server 2005 & National TV (USA, Canada) « The Paradigm Shift

  • But all filegroups are present in a single SAN disk. articles

  • Handy script to get the filegroups and other information for partitioned tables


  • This little script gives you the filegroups for each partition in a partitioned table.


  • Second, don't do this with a large database - the possibility of multiple files in the filegroups on a complex database is high, and you might not get them all.

    TechEd Bloggers Editor's Picks

  • As you mentioned, it does have it's limitations so the choice of storage isn't straightforward. e.g. Database Mirroring isn't supported and database snapshots don't work with FILESTREAM filegroups. - The SQL Server blog spot on the web

  • Now, the DifferentialBaseLSN of the file in the Primary filegroup is 28000000021500037, while the DifferentialBaseLSN of the files in the secondary filegroups remains unchanged at 28000000017700067.

    MSDN Blogs

  • Split the Search database tables on two different filegroups, and host the corresponding files on different sets of disks, to keep the crawl and query loads segregated and minimize I / O contention.

    MSDN Blogs

  • The author does not neglect to cover the area of data management, pointing out the relevance of proper placement, separation, and sizing of database files and filegroups, with particular emphasis on some of the default behavior (such as Autogrow settings or initial tempdb size), which suitability should be carefully considered, as well as requirements necessary to take advantage of the instant initialization functionality introduced in SQL Server 2008.

    Database Journal News


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