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. |
| 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.
