backupmediafamily

Transact-SQL Reference

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
2 = Temporary.
102 = Permanent.

Tape
5 = Temporary.
105 = Permanent.

Pipe
6 = Temporary.
106 = Permanent.

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.