Transact-SQL Reference
backupmediafamily
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 Tape Pipe 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. |