backupmediaset

Transact-SQL Reference

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.