Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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)