Export (0) Print
Expand All

backupfilegroup (Transact-SQL)

 

Applies To: SQL Server 2014, SQL Server 2016 Preview

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

System_CAPS_noteNote

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.

Applies to: SQL Server (SQL Server 2008 through current version).

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.

System_CAPS_importantImportant

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft