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. |
See Also
Reference
backupfile (Transact-SQL)
backupfilegroup (Transact-SQL)
backupmediaset (Transact-SQL)
backupset (Transact-SQL)
System Tables (Transact-SQL)