What Is a SQL Server Filegroup

Q

What Is a SQL Server Filegroup?

✍: FYIcenter.com

A

A SQL Server Filegroup represents a logical group of one or multiple physical Files. Each Filegroup will be used as a single logical unit to allocate storage space for database tables.

A SQL Server Database must have one Filegroup defined as the Default Filegroup, or Primary Filegroup.

The Default Filegroup must contain the Primary Physical File.

If you create a new table without specifying which Filegroup to use, it will be created on the Default Filegroup.

SQL Server Filegroup information is stored in a system table called sys.filegroups. Each record in this table represents a single SQL Server Logical Filegroup.

 

What Is sys.filegroups?

What Is sys.database_files?

SQL Server System Views and Functions

⇑⇑ SQL Server Storage Tutorials

2019-07-14, 227👍, 0💬