.png)
backupfilegroup (Transact-SQL)
Contains one row for each filegroup in a database at the time of backup. backupfilegroup is stored in the msdb database. backupfilegroup is new in the Microsoft SQL Server 2005 Database Engine.
 Note: |
|---|
| The backupfilegroup table shows the filegroup configuration of the database, not of the backup set. To identify whether a file is included in the backup set, use the is_present column of the backupfile table. For more information, see backupfile (Transact-SQL). |
| Important: |
|---|
| The same filegroup name can appear in different databases; however, each filegroup has its own GUID. Therefore, (backup_set_id, filegroup_guid) is a unique key that identifies a filegroup in backupfilegroup. Note that filegroup_guid is NULL for filegroups in databases that have been updated from earlier versions of SQL Server. |
| Column name | Data type | Description |
|---|---|---|
|
backup_set_id |
int |
Backup set containing this filegroup. |
|
name |
sysname |
Name of the filegroup. |
|
filegroup_id |
int |
ID of the filegroup; unique within the database. Corresponds to data_space_id in sys.filegroups. |
|
filegroup_guid |
uniqueidentifier |
Globally unique identifier for the filegroup. Can be NULL. |
|
type |
char(2) |
Content type, one of: FG = "Rows" Filegroup SL = SQL Server Log filegroup |
|
type_desc |
nvarchar(60) |
Description of function type, one of: ROWS_FILEGROUP SQL_LOG_FILEGROUP |
|
is_default |
bit |
The default filegroup, used when no filegroup is specified in CREATE TABLE or CREATE INDEX. |
|
is_readonly |
bit |
1 = Filegroup is read-only |
|
log_filegroup_guid |
uniqueidentifier |
Can be NULL. |
