Contains one row for each media family. This table is stored in the msdb database.
| Column name | Data type | Description |
|---|---|---|
| media_set_id | int NOT NULL REFERENCES backupmediaset(media_set_id) | Unique identification number that identifies the media set of which this family is a member. |
| family_sequence_number | tinyint NOT NULL | Position of this media family in the media set. |
| media_family_id | uniqueidentifier NULL | Unique identification number that identifies the media family. |
| media_count | int NULL | Number of media in the media family. |
| logical_device_name | nvarchar(128) NULL | Name of the backup device in sysdevices. logical_device_name is NULL if this is a temporary backup device (as opposed to a permanent backup device that exists in sysdevices). |
| physical_device_name | nvarchar(260) NULL | Physical name of the backup device. |
| device_type | tinyint NULL | Type of backup device: Disk 2 = Temporary 102 = Permanent Tape Pipe All permanent device names and device numbers can be found in sysdevices. |
| physical_block_size | int NULL | Physical block size that was used to write the media family. |