Export (0) Print
Expand All
Expand Minimize

backupmediafamily

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
(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.

Show:
© 2014 Microsoft