backupmediafamily (Transact-SQL)backupmediafamily (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 media family. 如果媒體家族位於鏡像媒體集中,則在這個媒體集中,這個家族的每個鏡像都會各有一個個別的資料列。If a media family resides in a mirrored media set, the family has a separate row for each mirror in the media set. 這份資料表儲存在msdb資料庫。This table is stored in the msdb database.

資料行名稱Column name 資料類型Data type 描述Description
media_set_idmedia_set_id intint 用來識別這個家族為其成員之媒體集的唯一識別碼。Unique identification number that identifies the media set of which this family is a member. 參考backupmediaset (media_set_id)References backupmediaset(media_set_id)
family_sequence_numberfamily_sequence_number tinyinttinyint 這個媒體家族在媒體集中的位置。Position of this media family in the media set.
media_family_idmedia_family_id uniqueidentifieruniqueidentifier 用來識別媒體家族的唯一識別碼。Unique identification number that identifies the media family. 可以是 NULL。Can be NULL.
media_countmedia_count intint 媒體家族中的媒體數目。Number of media in the media family. 可以是 NULL。Can be NULL.
logical_device_namelogical_device_name nvarchar(128)nvarchar(128) 在此備份裝置名稱sys.backup_devices.nameName of this backup device in 如果這是暫時的備份裝置 (而不是永久的備份裝置存在於sys.backup_devices),windows 7 logical_device_name是 NULL。If this is a temporary backup device (as opposed to a permanent backup device that exists in sys.backup_devices), the value of logical_device_name is NULL.
physical_device_namephysical_device_name nvarchar(260)nvarchar(260) 備份裝置的實體名稱。Physical name of the backup device. 可以是 NULL。Can be NULL. 此欄位會備份和還原程序之間共用。This field is shared between backup and restore process. 它可能包含原始備份的目的地路徑或原始還原來源路徑。It may contain the original backup destination path or the original restore source path. 取決於是否備份或還原第一次在伺服器上發生的資料庫。Depending on whether backup or restore occurred first on a server for a database. 請注意,從相同的備份檔案的連續還原會在還原期間更新的路徑,不論它的位置。Note that consecutive restores from the same backup file will not update the path regardless of it's location at restore time. 基於這個原因, physical_device_name欄位不能用來查看所使用的還原路徑。Because of this, physical_device_name field cannot be used to see the restore path used.
device_typedevice_type tinyinttinyint 備份裝置的類型:Type of backup device:

2 = 磁碟2 = Disk

5 = 磁帶5 = Tape

7 = 虛擬裝置7 = Virtual device

9 = azure 儲存體9 = Azure Storage

105 = 永久備份裝置。105 = A permanent backup device.

可以是 NULL。Can be NULL.

所有永久裝置名稱和裝置號碼位於sys.backup_devicesAll permanent device names and device numbers can be found in sys.backup_devices.
physical_block_sizephysical_block_size intint 用來寫入媒體家族的實體區塊大小。Physical block size used to write the media family. 可以是 NULL。Can be NULL.
mirrormirror tinyinttinyint 鏡像數目 (0-3)。Mirror number (0-3).


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)
backupmediaset (Transact-SQL) backupmediaset (Transact-SQL)
backupset (Transact-SQL) backupset (Transact-SQL)
系統資料表 (Transact-SQL)System Tables (Transact-SQL)