| title | backupmediaset (Transact-SQL) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 08/09/2016 | ||
| ms.prod | sql | ||
| ms.prod_service | database-engine | ||
| ms.reviewer | |||
| ms.technology | system-objects | ||
| ms.topic | language-reference | ||
| f1_keywords |
|
||
| dev_langs |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | d9c18a93-cab9-4db8-ae09-c6bd8145ab8f | ||
| author | stevestein | ||
| ms.author | sstein | ||
| manager | craigg |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]
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 [!INCLUDEmsCoName] [!INCLUDEssNoVersion] media sets have a UUID. For earlier versions of [!INCLUDEssNoVersion], 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 [!INCLUDEmsCoName] [!INCLUDEssNoVersion] is hexadecimal 0x1200. |
| MTF_major_version | tinyint | Major version number of [!INCLUDEmsCoName] 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. |
| is_encrypted | Bit | Whether the backup is encrypted: 0 = Not encrypted 1 = Encrypted |
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.
Backup and Restore Tables (Transact-SQL)
backupfile (Transact-SQL)
backupfilegroup (Transact-SQL)
backupmediafamily (Transact-SQL)
backupset (Transact-SQL)
System Tables (Transact-SQL)