Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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.

ms188759.note(en-US,SQL.90).gifNote:
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).

ms188759.note(en-US,SQL.90).gifImportant:
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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.