backupmediaset (Transact-SQL)backupmediaset (Transact-SQL)

適用於: 是SQL Server 否Azure SQL Database 否Azure Synapse Analytics (SQL DW) 否平行處理資料倉儲 APPLIES TO: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

每個備份組各含一個資料列。Contains one row for each backup media set. 這份資料表儲存在msdb資料庫。This table is stored in the msdb database.

資料行名稱Column name 資料類型Data type 描述Description
media_set_idmedia_set_id intint 唯一媒體集識別碼。Unique media set identification number. 識別,主索引鍵。Identity, primary key.
media_uuidmedia_uuid uniqueidentifieruniqueidentifier 媒體集的 UUID。The UUID of the media set. 所有MicrosoftMicrosoftSQL ServerSQL Server媒體集都有一個 UUID。All MicrosoftMicrosoft SQL ServerSQL Server media sets have a UUID.

對於較早版本SQL ServerSQL Server,不過,如果媒體集包含一個媒體家族media_uuid資料行可能為 NULL (media_family_count為 1)。For earlier versions of SQL ServerSQL 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_countmedia_family_count tinyinttinyint 媒體集中的媒體家族數目。Number of media families in the media set. 可以是 NULL。Can be NULL.
namename nvarchar(128)nvarchar(128) 媒體集的名稱。Name of the media set. 可以是 NULL。Can be NULL.

如需詳細資訊,請參閱 MEDIANAME 和 MEDIADESCRIPTION,在BACKUP (TRANSACT-SQL)For more information, see MEDIANAME and MEDIADESCRIPTION in BACKUP (Transact-SQL).
descriptiondescription nvarchar(255)nvarchar(255) 媒體集的文字描述。Textual description of the media set. 可以是 NULL。Can be NULL.

如需詳細資訊,請參閱 MEDIANAME 和 MEDIADESCRIPTION,在BACKUP (TRANSACT-SQL)For more information, see MEDIANAME and MEDIADESCRIPTION in BACKUP (Transact-SQL).
software_namesoftware_name nvarchar(128)nvarchar(128) 寫入媒體標籤的備份軟體名稱。Name of the backup software that wrote the media label. 可以是 NULL。Can be NULL.
software_vendor_idsoftware_vendor_id intint 寫入備份媒體標籤的軟體供應商識別碼。Identification number of the software vendor that wrote the backup media label. 可以是 NULL。Can be NULL.

MicrosoftMicrosoftSQL ServerSQL Server是十六進位 0x1200。The value for MicrosoftMicrosoft SQL ServerSQL Server is hexadecimal 0x1200.
MTF_major_versionMTF_major_version tinyinttinyint 用來產生這個媒體集之 MicrosoftMicrosoft Tape Format 的主要版本號碼。Major version number of MicrosoftMicrosoft Tape Format used to generate this media set. 可以是 NULL。Can be NULL.
mirror_countmirror_count tinyinttinyint 媒體集中的鏡像數目。Number of mirrors in the media set.
is_password_protectedis_password_protected bitbit 這是指媒體集是否有密碼保護:Is the media set password protected:

0 = 無保護0 = Not protected

1 = 保護1 = Protected
is_compressedis_compressed bitbit 備份是否經過壓縮:Whether the backup is compressed:

0 = 未壓縮0 = Not compressed

1 = 已壓縮1 = Compressed

期間msdb升級時,此值設定為 NULL。During an msdb upgrade, this value is set to NULL. 這表示非壓縮的備份。which indicates an uncompressed backup.
is_encryptedis_encrypted BitBit 備份是否經過加密:Whether the backup is encrypted:

0 = 未加密0 = Not encrypted

1 = 已加密1 = Encrypted

備註Remarks

RESTORE VERIFYONLY FROM backup_device WITH LOADHISTORY 會的資料行backupmediaset媒體集標頭的適當值的資料表。RESTORE VERIFYONLY FROM backup_device WITH LOADHISTORY populates the columns of the backupmediaset table with the appropriate values from the media-set header.

若要減少此資料表和其他備份和記錄資料表中的資料列數目,請執行sp_delete_backuphistory預存程序。To reduce the number of rows in this table and in other backup and history tables, execute the sp_delete_backuphistory stored procedure.

另請參閱See Also

備份與還原資料表(Transact SQL) Backup and Restore Tables (Transact-SQL)
backupfile (Transact-SQL) backupfile (Transact-SQL)
backupfilegroup (Transact-SQL) backupfilegroup (Transact-SQL)
backupmediafamily (Transact-SQL) backupmediafamily (Transact-SQL)
backupset (Transact-SQL) backupset (Transact-SQL)
系統資料表 (Transact-SQL)System Tables (Transact-SQL)