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. |
See Also
Reference
backupfile (Transact-SQL)
backupmediafamily (Transact-SQL)
backupmediaset (Transact-SQL)
backupset (Transact-SQL)
System Tables (Transact-SQL)