backupmediaset (Transact-SQL)
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 |
Unique media set identification number. Identity, primary key. |
media_uuid |
uniqueidentifier |
The UUID of the media set. All Microsoft SQL Server media sets have a UUID. For earlier versions of SQL Server, however, if a media set contains only one media family, the media_uuid column might be NULL (media_family_count is 1). |
media_family_count |
tinyint |
Number of media families in the media set. Can be NULL. |
name |
nvarchar(128) |
Name of the media set. Can be NULL. For more information, see MEDIANAME and MEDIADESCRIPTION in BACKUP (Transact-SQL). |
description |
nvarchar(255) |
Textual description of the media set. Can be NULL. For more information, see MEDIANAME and MEDIADESCRIPTION in BACKUP (Transact-SQL). |
software_name |
nvarchar(128) |
Name of the backup software that wrote the media label. Can be NULL. |
software_vendor_id |
int |
Identification number of the software vendor that wrote the backup media label. Can be NULL. The value for Microsoft SQL Server is hexadecimal 0x1200. |
MTF_major_version |
tinyint |
Major version number of Microsoft Tape Format used to generate this media set. Can be NULL. |
mirror_count |
tinyint |
Number of mirrors in the media set. |
is_password_protected |
bit |
Is the media set password protected: 0 = Not protected 1 = Protected |
is_compressed |
bit |
Whether the backup is compressed: 0 = Not compressed 1 = Compressed During an msdb upgrade, this value is set to NULL. which indicates an uncompressed backup. |
Remarks
RESTORE VERIFYONLY FROM backup_device WITH LOADHISTORY populates the columns of the backupmediaset table with the appropriate values from the media-set header.
To reduce the number of rows in this table and in other backup and history tables, execute the sp_delete_backuphistory stored procedure.