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, 1290🔥, 0💬
Popular Posts:
How to expand IPv6 addresses? In order to help your programming or testing tasks, FYIcenter.com has ...
How to validate email address format? In order to help your programming or testing tasks, FYIcenter....
What are JMeter command line options? You can get see JMeter command line options by running this co...
Where to find tutorials on Apache JMeter test tool? I want to know how to use Apache JMeter. Here is...
How to convert IPv4 to IPv6 addresses? In order to help your programming or testing tasks, FYIcenter...