SQL Server Interview Question #279

What are filegroups?

SQL Server Internals & Administration Senior Advanced

Detailed Explanation

A filegroup is a logical container for one or more SQL Server data files. The PRIMARY filegroup exists by default, and additional user-defined filegroups can be created.

Filegroups can support administrative, placement, partitioning, backup/restore, and large-database design requirements. They are not automatically a performance improvement; benefits depend on storage architecture and workload.

Transaction log files are not members of data filegroups.

Code Example

ALTER DATABASE SalesDb
ADD FILEGROUP ArchiveFG;