# backupmediafamily - Catalog: `msdb` - Schema: `dbo` - Primary Keys: `media_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 `backupmediafamily` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `device_type` | `int16` | | ☐ | | | `family_sequence_number` | `int16` | | ☐ | | | `logical_device_name` | `string` | | ☐ | | | `media_count` | `int32` | | ☐ | | | `media_family_id` | `guid` | | ☐ | | | `media_set_id` | `int32` | | ☐ | | | `mirror` | `int16` | | ☐ | | | `physical_block_size` | `int32` | | ☐ | | | `physical_device_name` | `string` | | ☐ | |