# backupfile - Catalog: `msdb` - Schema: `dbo` - Primary Keys: `backup_set_id` The data in this table is partitioned per value of the column. Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `backupfile` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `backed_up_page_count` | `decimal` | | ☐ | | | `backup_set_id` | `int32` | | ☐ | | | `backup_size` | `decimal` | | ☐ | | | `create_lsn` | `decimal` | | ☐ | | | `differential_base_guid` | `guid` | | ☐ | | | `differential_base_lsn` | `decimal` | | ☐ | | | `drop_lsn` | `decimal` | | ☐ | | | `file_guid` | `guid` | | ☐ | | | `file_number` | `decimal` | | ☐ | | | `file_size` | `decimal` | | ☐ | | | `file_type` | `char` | | ☐ | | | `filegroup_guid` | `guid` | | ☐ | | | `filegroup_name` | `string` | | ☐ | | | `first_family_number` | `int16` | | ☐ | | | `first_media_number` | `int16` | | ☐ | | | `is_present` | `boolean` | | ☐ | | | `is_readonly` | `boolean` | | ☐ | | | `logical_name` | `string` | | ☐ | | | `page_size` | `int32` | | ☐ | | | `physical_drive` | `string` | | ☐ | | | `physical_name` | `string` | | ☐ | | | `read_only_lsn` | `decimal` | | ☐ | | | `read_write_lsn` | `decimal` | | ☐ | | | `source_file_block_size` | `decimal` | | ☐ | | | `state` | `int16` | | ☐ | | | `state_desc` | `string` | | ☐ | |