Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize


SQL Server 2000

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:

2 = Temporary.
102 = Permanent.

5 = Temporary.
105 = Permanent.

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft