backupfile

Transact-SQL Reference

Transact-SQL Reference

backupfile

Contains one row for each data or log file that is backed up. This table is stored in the msdb database.

Column name Data type Description
backup_set_id int NOT NULL REFERENCES backupset(backup_
set_id)
Unique identification number of the file containing the backup set.
first_family_number tinyint NULL Family number of the first media containing this backup file.
first_media_number smallint NULL Media number of the first media containing this backup file.
filegroup_name nvarchar(128) NULL Name of the filegroup containing the database (data or log) file backed up.
page_size int NULL Size of the page, in bytes.
file_number numeric(10,0) NOT NULL Unique file identification number (FILE_ID).
backed_up_page_count numeric(10,0) NULL Number of pages backed up.
file_type char(1) NULL File backed up. Can be either D for data or L for log.
source_file_block_size numeric(10,0) NULL Device that the original data or log file resided on when it was backed up.
file_size numeric(20,0) NULL Length of the file that is backed up, in bytes.
logical_name nvarchar(128) NULL Logical name of the file that is backed up.
physical_drive varchar(260) NULL Physical drive or partition name.
physical_name varchar(260) NULL Remainder of the physical (operating system) file name.