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 |
|Unique identification number that identifies the media set of which this family is a member.|
|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:
All permanent device names and device numbers can be found in sysdevices.
|physical_block_size||int NULL||Physical block size used to write the media family.|