backupfilegroup (Transact-SQL)


THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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

System_CAPS_ICON_note.jpg 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 nameData typeDescription
backup_set_idintBackup set containing this filegroup.
namesysnameName of the filegroup.
filegroup_idintID of the filegroup; unique within the database. Corresponds to data_space_id in sys.filegroups.
filegroup_guiduniqueidentifierGlobally unique identifier for the filegroup. Can be NULL.
typechar(2)Content type, one of:

FG = "Rows" Filegroup

SL = SQL Server Log filegroup
type_descnvarchar(60)Description of function type, one of:


is_defaultbitThe default filegroup, used when no filegroup is specified in CREATE TABLE or CREATE INDEX.
is_readonlybit1 = Filegroup is read-only.
log_filegroup_guiduniqueidentifierCan be NULL.
System_CAPS_ICON_important.jpg 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.

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.

Backup and Restore Tables (Transact-SQL)
backupfile (Transact-SQL)
backupmediafamily (Transact-SQL)
backupmediaset (Transact-SQL)
backupset (Transact-SQL)
System Tables (Transact-SQL)

Community Additions