Transact-SQL Reference
backupmediaset
Contains one row for each backup media set. This table is stored in the msdb database.
| Column name | Data type | Description |
|---|---|---|
| media_set_id | int IDENTITY PRIMARY KEY | Unique media set identification number. |
| media_uuid | uniqueidentifier NULL | Number of media in the media set. If only one media family in the backup set, then this column is NULL (media_family_count is 1). |
| media_family_count | tinyint NULL | Number of media families in the media set. |
| name | nvarchar(128) NULL | Name of the media set. For more information, see MEDIANAME and MEDIADESCRIPTION in BACKUP. |
| description | nvarchar(255) NULL | Textual description of the media set. For more information, see MEDIANAME and MEDIADESCRIPTION in BACKUP. |
| software_name | nvarchar(128) NULL | Name of the backup software that wrote the media label. |
| software_vendor_id | int NULL | Identification number of the software vendor that wrote the backup media label. The Microsoft® SQL Server™ value for this column is hexadecimal 0x1200. |
| MTF_major_version | tinyint NULL | Major version number of Microsoft Tape Format used to generate this media set. |