backupfilegroup (Transact-SQL)backupfilegroup (Transact-SQL)

適用於: 是SQL Server 否Azure SQL Database 否Azure Synapse Analytics (SQL DW) 否平行處理資料倉儲 APPLIES TO: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

針對備份時在資料庫中的每個檔案群組,各包含一個資料列。Contains one row for each filegroup in a database at the time of backup. backupfilegroup會儲存在msdb資料庫。backupfilegroup is stored in the msdb database.


Backupfilegroup表顯示的資料庫,而不是備份組的檔案群組設定。The backupfilegroup table shows the filegroup configuration of the database, not of the backup set. 若要識別是否檔案包含在備份組,使用is_present資料行backupfile資料表。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_idbackup_set_id intint 包含這個檔案群組的備份組。Backup set containing this filegroup.
namename sysnamesysname 檔案群組的名稱。Name of the filegroup.
filegroup_idfilegroup_id intint 檔案群組的識別碼,它在資料庫中是唯一的。ID of the filegroup; unique within the database. 對應至data_space_idsys.filegroupsCorresponds to data_space_id in sys.filegroups.
filegroup_guidfilegroup_guid uniqueidentifieruniqueidentifier 檔案群組的全域唯一識別碼。Globally unique identifier for the filegroup. 可以是 NULL。Can be NULL.
typetype char(2)char(2) 這是內容類型,它有下列幾種:Content type, one of:

FG = "Rows" 檔案群組FG = "Rows" Filegroup

SL = SQL ServerSQL Server 記錄檔案群組SL = SQL ServerSQL Server Log filegroup
type_desctype_desc nvarchar(60)nvarchar(60) 這是函數類型的描述,它有下列幾種:Description of function type, one of:


is_defaultis_default bitbit 在 CREATE TABLE 或 CREATE INDEX 中未指定檔案群組時,所使用的預設檔案群組。The default filegroup, used when no filegroup is specified in CREATE TABLE or CREATE INDEX.
is_readonlyis_readonly bitbit 1 = 檔案群組是唯讀的。1 = Filegroup is read-only.
log_filegroup_guidlog_filegroup_guid uniqueidentifieruniqueidentifier 可以是 NULL。Can be NULL.



相同的檔案群組名稱可以出現在不同的資料庫中;每個檔案群組都有它自己的 GUID。The same filegroup name can appear in different databases; however, each filegroup has its own GUID. 因此, (backup_set_id,filegroup_guid) 是可識別中的檔案群組的唯一索引鍵backupfilegroupTherefore, (backup_set_id,filegroup_guid) is a unique key that identifies a filegroup in backupfilegroup.

RESTORE VERIFYONLY FROM backup_device WITH LOADHISTORY 會的資料行backupmediaset媒體集標頭的適當值的資料表。RESTORE VERIFYONLY FROM backup_device WITH LOADHISTORY populates the columns of the backupmediaset table with the appropriate values from the media-set header.

若要減少此資料表和其他備份和記錄資料表中的資料列數目,請執行sp_delete_backuphistory預存程序。To reduce the number of rows in this table and in other backup and history tables, execute the sp_delete_backuphistory stored procedure.

另請參閱See Also

備份與還原資料表(Transact SQL) Backup and Restore Tables (Transact-SQL)
backupfile (Transact-SQL) backupfile (Transact-SQL)
backupmediafamily (Transact-SQL) backupmediafamily (Transact-SQL)
backupmediaset (Transact-SQL) backupmediaset (Transact-SQL)
backupset (Transact-SQL) backupset (Transact-SQL)
系統資料表 (Transact-SQL)System Tables (Transact-SQL)