backupfilegroup (Transact-SQL)
Contains one row for each filegroup in a database at the time of backup. backupfilegroup is stored in the msdb database.
[!UWAGA]
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. |
Uwagi
.gif "Ważna informacja") Ważne: |
|---|
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.
Zobacz także
Odwołanie
backupmediafamily (Transact-SQL)