Collections:
What Is a SQL Server Filegroup
What Is a SQL Server Filegroup?
✍: FYIcenter.com
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.
2019-07-14, 557👍, 0💬
Popular Posts:
How to generate IPv6 Addresses? To help you to obtain some IPv6 addresses for testing purpose, FYIce...
How to generate IP Addresses? To help you to obtain some IP addresses for testing purpose, FYIcenter...
How to perform UUDecode (Unix-to-Unix Decode)? UUEncode is Unix-to-Unix encoding used on Unix system...
How to perform regular expression pattern match with multiple occurrences? To perform a regular expr...
How to list all variables with the Debug PostProcessor in JMeter? If you want to see a list of all y...