Export (0) Print
Expand All
1 out of 1 rated this helpful - Rate this topic

backupmediafamily (Transact-SQL)

Contains one row for each media family. If a media family resides in a mirrored media set, the family has a separate row for each mirror in the media set. Media sets that exist at the time of upgrade to Microsoft SQL Server 2005 have a single row per media family. This table is stored in the msdb database.

Column name Data type Description

media_set_id

int

Unique identification number that identifies the media set of which this family is a member. References backupmediaset(media_set_id)

family_sequence_number

tinyint

Position of this media family in the media set.

media_family_id

uniqueidentifier

Unique identification number that identifies the media family. Can be NULL.

media_count

int

Number of media in the media family. Can be NULL.

logical_device_name

nvarchar(128)

Name of this backup device in sys.backup_devices.name. If this is a temporary backup device (as opposed to a permanent backup device that exists in sys.backup_devices), the value of logical_device_name is NULL.

physical_device_name

nvarchar(260)

Physical name of the backup device. Can be NULL.

device_type

tinyint

Type of backup device:

Disk:

2 = Temporary.

102 = Permanent.

Tape:

5 = Temporary.

105 = Permanent.

Can be NULL.

All permanent device names and device numbers can be found in sys.backup_devices.

physical_block_size

int

Physical block size used to write the media family. Can be NULL.

mirror

tinyint

Mirror number (0-3). For media sets that exist at the time of upgrade to Microsoft SQL Server 2005, the mirror number is 0.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.