1.

What Is A File Group?

Answer»

File group is a group of files logically grouped together.

There are two types of filegroups:

  • Primary :- The primary file group contains the primary data file and any other files not specifically assigned to another file group. All pages for the SYSTEM TABLES are allocated in the primary file group.
  • User-defined :- User-defined file groups are any file groups specified using the FILEGROUP KEYWORD in a CREATE DATABASE or ALTER DATABASE statement.

File group is a group of files logically grouped together.

There are two types of filegroups:


Discussion

No Comment Found

Related InterviewSolutions