Share via


backupfilegroup (Transact-SQL)

Contains one row for each filegroup in a database at the time of backup. backupfilegroup is stored in the msdb database.

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.

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.

Remarks

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 SQL Server 2000.

RESTORE VERIFYONLY FROM backup_device WITH LOADHISTORY populates the columns of the backupmediaset table with the appropriate values from the media-set header.

To reduce the number of rows in this table and in other backup and history tables, execute the sp_delete_backuphistory stored procedure.