媒體集、媒體家族與備份組 (SQL Server)Media Sets, Media Families, and Backup Sets (SQL Server)

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

本主題介紹 SQL ServerSQL Server 備份和還原的基本備份媒體詞彙,適合供初次使用 SQL ServerSQL Server的使用者閱讀。This topic introduces the basic backup-media terminology of SQL ServerSQL Server backup and restore and is intended for readers who are new to SQL ServerSQL Server.

此主題描述 SQL ServerSQL Server 用於備份媒體的格式、備份媒體與備份裝置之間的對應、備份在備份媒體上的組織,以及媒體集和媒體家族的數個考量。This topic describes the format that SQL ServerSQL Server uses for backup media, the correspondence between backup media and backup devices, the organization of backups on backup media, and several considerations for media sets and media families. 此主題也描述第一次使用備份媒體,或將舊媒體集取代為新媒體集之前初始化或格式化備份媒體的步驟、如何覆寫媒體集中舊備份組的步驟,以及如何將新備份組附加至媒體集的步驟。The topic also describes the steps initializing or formatting backup media before you use it for the first time or replace an old media set with a new media set, how to overwrite old backup sets in a media set, and how to append new backup sets to a media set.

注意!NOTE! 如需將 SQL Server 備份放至 Windows Azure Blob 儲存體服務的詳細資訊,請參閱 使用 Microsoft Azure Blob 儲存體服務進行 SQL Server 備份及還原For more information on SQL Server backup to the Windows Azure Blob storage service,, see, SQL Server Backup and Restore with Microsoft Azure Blob Storage Service.

詞彙Terms

媒體集media set
按順序排列的備份媒體集合 (磁帶或磁碟檔案),由一個或多個備份作業使用固定的備份裝置類型與數量寫入。An ordered collection of backup media, tapes or disk files, to which one or more backup operations have written using a fixed type and number of backup devices.

媒體家族media family
在單一非鏡像裝置上或媒體集的一組鏡像裝置上所建立的備份。Backups created on a single nonmirrored device or a set of mirrored devices in a media set

備份組backup set
透過成功的備份作業,加入至媒體集的備份內容。The backup content that is added to a media set by a successful backup operation.

媒體集、媒體家族和備份組的概觀Overview of media sets, media families, and backup sets

單一媒體集是由一組一個或多個備份媒體上的備份組成。The backups on a set of one or more backup media compose a single media set. 「媒體集」 (Media Set) 是按順序排列的「備份媒體」 (Backup Media) 集合 (磁帶、磁碟檔案或Azure Blob),由一個或多個備份作業使用固定的備份裝置類型與數量寫入。A media set is an ordered collection of backup media, tapes or disk files, or Azure Blobs, to which one or more backup operations have written using a fixed type and number of backup devices. 給定的媒體集會使用磁帶機、磁碟機或Azure Blob,但是不得為兩個以上的組合。A given media set uses tape drives, or disk drives or Azure blobs, but not a combination of two or more.

範例: 與媒體集建立關聯的備份裝置可能是三個磁帶機,分別名為 \\.\TAPE0\\.\TAPE1\\.\TAPE2Example: Backup devices associated with a media set might be three tape drives named \\.\TAPE0, \\.\TAPE1, and \\.\TAPE2. 此媒體集僅包含磁帶,一開始最少有三個磁帶 (每個磁帶機一個)。That media set contains only tapes, starting with a minimum of three tapes (one per drive). 備份裝置類型與數量是在媒體集建立時確立,而且無法變更。The type and number of backup devices are established when a media set is created, and they cannot be changed. 不過,可在必要時以相同類型的裝置取代備份和還原作業間的指定裝置。However, if necessary, between backup and restore operations a given device can be replaced with a device of the same type.

媒體集是在備份作業格式化備份媒體期間,於備份媒體上建立。A media set is created on the backup media during a backup operation by formatting the backup media. 如需詳細資訊,請參閱本主題稍後的 建立新媒體集For more information, see Creating a New Media Set, later in this topic. 完成格式化後,每個檔案或磁帶會包含媒體集的媒體標頭,且備妥要接收備份內容。After formatting, each file or tape contains a media header for the media set and is ready to receive backup content. 有了適當的標頭,備份作業就可以在指定供作業使用的所有備份裝置上,繼續將指定的資料備份至備份媒體。With the header in place, the backup operation proceeds to back up the specified data to the backup media on all of the backup devices specified for the operation.

注意!NOTE! 媒體集可以鏡像,避免損毀媒體磁碟區 (磁帶或磁碟檔案)。Media sets can be mirrored to protect against a damaged media volume (a tape or disk file). 如需詳細資訊,請參閱本主題稍後的 鏡像備份媒體集 (SQL Server)的使用者閱讀。For more information, see Mirrored Backup Media Sets (SQL Server).

壓縮和未壓縮的備份無法在媒體集中一起出現。Compressed and uncompressed backups cannot occur together in a media set. 任何 SQL Server 2008SQL Server 2008 或更新版本都可以讀取壓縮的備份。Any edition of SQL Server 2008SQL Server 2008 or later can read compressed backups. 如需詳細資訊,請參閱備份壓縮 (SQL Server)For more information, see Backup Compression (SQL Server).

媒體家族Media Families

在單一非鏡像裝置上或媒體集鏡像裝置組上所建立的備份,即構成一個 「媒體家族」 (Media family)。Backups created on a single nonmirrored device or a set of mirrored devices in a media set constitute a media family. 媒體集使用的備份裝置數量決定媒體集內的媒體家族數。The number of backup devices used for the media set determines the number of media families in a media set. 例如,如果媒體集使用兩個非鏡像的備份裝置,此媒體集即包含兩個媒體家族。For example, if a media set uses two nonmirrored backup devices, the media set contains two media families.

在鏡像的媒體集中,每個媒體家族都是鏡像。In a mirrored media set, each media family is mirrored. 例如,如果使用六個備份裝置格式化媒體集,其中兩個使用鏡像,共有三個媒體家族,每個都包含兩份等量的備份資料。For example, if six backup devices are used to format a media set, where two mirrors are used, there are three media families, each containing two equivalent copies of backup data. 如需鏡像媒體集的詳細資訊,請參閱 鏡像備份媒體集 (SQL Server)的使用者閱讀。For more information about mirrored media sets, see Mirrored Backup Media Sets (SQL Server).

媒體家族內的每個磁帶或磁碟都會指派一個 「媒體序號」Each tape or disk in a media family is assigned a media sequence number. 磁碟的媒體序號永遠是 1。The media sequence number of a disk is always 1. 在磁帶媒體家族中,初始磁帶的序號為 1,第二個磁帶的序號為 2,以此類推。In a tape media family, the sequence number of the initial tape is 1, the sequence number of the second tape is 2, and so forth. 如需詳細資訊,請參閱本主題稍後的 媒體集、媒體家族與備份組 (SQL Server)的使用者閱讀。For more information, see Media Sets, Media Families, and Backup Sets (SQL Server).

媒體標頭The media header

備份媒體 (磁碟檔案或磁帶) 的每個磁碟區都包含一個媒體標頭,此標頭是由使用磁帶 (或磁碟) 的第一個備份作業所建立。Every volume of backup media (disk file or tape) contains a media header that is created when by the first backup operation that uses the tape (or disk). 此標頭會保持不變,直到重新格式化媒體。That header remains intact until the media is reformatted.

媒體標頭包含識別媒體 (磁碟檔案或磁帶) 所需的所有資訊,而標頭會位在所屬的媒體家族內。The media header contains all of the information required to identify the media (disk file or tape) and its place within the media family to which it belongs. 這項資訊包括:This information includes:

  • 媒體的名稱。The name of the media.

    (選擇性) 建議您使用可清楚識別媒體的媒體名稱。The media name is optionally, but we recommend consistently using media names that clearly identify your media. 媒體名稱是由格式化該媒體的人指派。A media name is assigned by whoever formats the media.

  • 媒體集的唯一識別碼。The unique identification number of the media set.

  • 媒體集內的媒體家族編號。The number of media families in the media set.

  • 包含此媒體之媒體家族的序號。The sequence number of the media family containing this media.

  • 媒體家族的唯一識別碼。The unique identification number for the media family.

  • 媒體家族內此媒體的序號。The sequence number of this media in the media family. 對於磁碟檔案,這個值永遠為 1。For a disk file, this value is always 1.

  • 媒體描述是否包含 MTF 媒體標籤或媒體描述。Whether the media description contains an MTF media label or a media description.

    注意!NOTE! 備份或還原作業所用的所有媒體都使用稱為 MicrosoftMicrosoft Tape Format (MTF) 的標準備份格式。All media that is used for a backup or restore operation use a standard backup format called MicrosoftMicrosoft Tape Format (MTF). MTF 允許使用者指定含有 MTF 特定描述的磁帶標籤。MTF allows users to specify a tape label that contains a MTF-specific description. SQL ServerSQL Server 會保留另一個應用程式所寫入的任何 MTF 媒體標籤,但是不會寫入 MTF 媒體標籤。preserves any MTF media label written by another application but does not write MTF media labels.

  • MicrosoftMicrosoft Tape Format 媒體標籤或媒體描述 (自由形式文字)。The MicrosoftMicrosoft Tape Format media label or the media description (in free-form text).

  • 寫入標籤的備份軟體名稱。The name of the backup software that wrote the label.

  • 格式化媒體之軟體廠商的唯一廠商識別碼。The unique vendor identification number of the software vendor that formatted the media.

  • 寫入標籤時的日期和時間。The date and time the label was written.

  • 媒體集內的鏡像數目 (1-4);1 代表無鏡像裝置。The number of mirrors in the set (1-4); 1 indicates an unmirrored device.

SQL Server 2017SQL Server 2017 可處理由舊版 SQL ServerSQL Server格式化的媒體。can process media formatted by earlier versions of SQL ServerSQL Server.

備份組Backup sets

成功的備份作業會將一個 「備份組」 (Backup set) 加入至媒體集。A successful backup operation adds a single backup set to the media set. 這個備份組是根據備份所屬的媒體集加以描述。The backup set is described in terms of the media set to which the backup belongs. 如果備份媒體僅由一個媒體家族組成,則該家族就包含整個備份組。If the backup media consists of only one media family, that family contains the entire backup set. 如果備份媒體由多個媒體家族組成,則備份組會分散於其中。If the backup media consists of multiple media families, the backup set is distributed among them. 在每個媒體上,備份組都會包含描述該備份組的標頭。On each medium, the backup set contains a header that describes the backup set.

這個範例顯示一個 Transact-SQLTransact-SQL 陳述式,為使用三個磁帶機做為備份裝置的 MyAdvWorks_MediaSet_1 資料庫,建立稱為 AdventureWorks2012AdventureWorks2012 的媒體集:This example shows a Transact-SQLTransact-SQL statement that creates a media set called MyAdvWorks_MediaSet_1 for the AdventureWorks2012AdventureWorks2012 database using three tape drives as backup devices:

BACKUP DATABASE AdventureWorks2012  
TO TAPE = '\\.\tape0', TAPE = '\\.\tape1', TAPE = '\\.\tape2'  
WITH   
   FORMAT,  
   MEDIANAME = 'MyAdvWorks_MediaSet_1'  

如果成功,此備份作業會產生新的媒體集,內含新的媒體標頭與一個分佈於三個磁帶的備份組。If successful, this backup operation results in a new media set containing a new media header and one backup set spread across three tapes. 下圖說明這些結果:The following figure illustrates these results:

媒體標頭和 3 個磁帶上的第一個備份集Media header and first backup set on 3 tapes

一般來說,媒體集建立之後,隨後接連發生的備份作業,將會它們的備份組附加到媒體集。Typically, after a media set is created, subsequent backup operations, one after another, append their backup sets to the media set. 媒體集是由備份組使用的所有媒體組成,不論包含的媒體或備份裝置數目為何。All of the media used by a backup set make up the media set, regardless of the number of media or backup devices involved. 備份組會根據它們在媒體集內的位置連續編號,您可以用以指定要還原的備份組。Backup sets are sequentially numbered by their position in the media set, allowing you to specify which backup set to restore.

媒體集的每個備份作業必須寫入同一個的備份裝置編號與類型。Every backup operation to a media set must write to the same number and type of backup devices. 如同第一個備份組一樣有多個裝置,隨後每個備份組的內容會分佈在所有裝置上的備份媒體中。With multiple devices, as with the first backup set, the content of every subsequent backup set is distributed among the backup media on all of the devices. 繼續上述範例,第二個備份作業 (差異備份) 將資訊附加到相同的媒體集:To continue the above example, a second backup operation (a differential backup) appends information to the same media set:

BACKUP DATABASE AdventureWorks2012  
TO TAPE = '\\.\tape0', TAPE = '\\.\tape1', TAPE = '\\.\tape2'  
WITH   
   NOINIT,  
   MEDIANAME = 'AdventureWorksMediaSet1',  
   DIFFERENTIAL  

注意!NOTE! NOINIT 選項是預設值,為了表明而包括於上。The NOINIT option is the default, but is included for clarity.

如果第二個備份作業成功,就會將第二個備份組寫入媒體集,接連散發備份內容:If the second backup operation succeeds, it writes a second backup set to the media set, with the following distribution of backup content:

分散在 3 個媒體集磁帶上的第二個備份集Second backup set spread across 3 media-set tapes

當您要還原備份時,可以使用 FILE 選項來指定所要使用的備份。When you are restoring backups, you can use you the FILE option to specify which backups you want to use. 下列範例示範 FILE = backup_set_file_number 子句在還原 AdventureWorks2012AdventureWorks2012 資料庫的完整資料庫備份時的用法,並接著示範在相同媒體集上進行差異資料庫備份。The following example shows the use of FILE =backup_set_file_number clauses when restoring a full database backup of the AdventureWorks2012AdventureWorks2012 database followed by a differential database backup on the same media set. 這個媒體集使用三個備份磁帶,分別位於磁帶機 \\.\tape0tape1tape2The media set uses three backup tapes, which are on tape drives \\.\tape0, tape1, and tape2.

RESTORE DATABASE AdventureWorks2012 FROM TAPE = '\\.\tape0', TAPE = '\\.\tape1', TAPE = '\\.\tape2'  
   WITH   
   MEDIANAME = 'AdventureWorksMediaSet1',  
   FILE=1,   
   NORECOVERY;  
RESTORE DATABASE AdventureWorks2012 FROM TAPE = '\\.\tape0', TAPE = '\\.\tape1', TAPE = '\\.\tape2'   
   WITH   
   MEDIANAME = 'AdventureWorksMediaSet1',  
   FILE=2,   
   RECOVERY;  
GO  

如需儲存媒體集與其媒體家族及備份組相關資訊之記錄資料表的相關資訊,請參閱 備份記錄與標頭資訊 (SQL Server)的使用者閱讀。For information about the history tables that store information about media sets and their media families and backup sets, see Backup History and Header Information (SQL Server).

媒體集內的備份媒體數量取決於數個因素:The number of backup media in a media set depends on several factors:

  • 備份裝置數量Number of backup devices

  • 備份裝置類型Type of backup devices

  • 備份組數量Number of backup sets

Creating a new media setCreating a new media set

若要建立新的媒體集,您必須將備份媒體 (一個或多個磁帶或磁碟檔案) 格式化。To create a new media set, you must format the backup media (one or more tapes or disk files). 格式化的過程會變更備份媒體,如下所示:The formatting process changes the backup media as follows:

  1. 刪除舊標頭 (若有的話),有效率地刪除備份媒體上先前的內容。Deletes the old header (if any), effectively deleting the previous contents of the backup media.

    將磁帶裝置格式化,會刪除目前所掛載磁帶上的所有先前內容。Formatting a tape device deletes all previous contents of the currently mounted tape. 將磁碟格式化,則只會影響您指定給備份作業的檔案。Formatting a disk affects only the file that you specify for the backup operation

  2. 在每個備份裝置的備份媒體 (磁帶或磁碟檔案) 上寫入新的媒體標頭。Writes a new media header on the backup media (tape or disk file) on each of the backup devices.

備份至現有的媒體集Backing up to an existing media set

備份至現有的媒體集時,您有下列兩個選項:When you are backing up to an existing media set, you have the following two options:

  • 附加至現有的媒體集。Append to the existing backup set.

    為了盡可能善用可用空間,新的備份組通常會附加至現有的媒體集。To make the best possible use of the available space, new backup sets typically are appended to existing media set. 附加至備份會保留任何先前的備份。Appending to the backup preserves any prior backups. 如需詳細資訊,請參閱本節稍後的 附加至現有備份組For more information, see Appending to Existing Backup Sets, later in this section.

附加動作是 BACKUP 的預設行為,可以使用 NOINIT 選項明確地指定。Appending, which is the default behavior of the BACKUP, can be explicitly specified by using the NOINIT option.

  • 以目前的備份來覆寫所有現有的備份組,將目前的媒體標頭留在原處。Overwrite all existing backup sets with the current backup, leaving the current media header in place.

    SQL ServerSQL Server 備份具有保護機制,可防止您在無意中覆寫媒體。backup has safeguards to prevent you from accidentally overwriting media. 但是若備份組已達到預先定義的期限,備份就會自動覆寫備份組。However, backup can automatically overwrite backup sets that have reached a predefined expiration date.

    針對磁帶標頭,適當地保留標頭有其意義。For tape headers, leaving the header in place can make sense. 如需詳細資訊,請參閱本節稍後的 覆寫備份組For more information, see Overwriting Backup Sets, later in this section.

    若要覆寫現有的備份組,可以使用 BACKUP 陳述式的 INIT 選項來指定。Overwriting existing backup sets is specified by using the INIT option of the BACKUP statement.

Appending to existing backup setsAppending to existing backup sets

不同時間執行的備份可以寫在相同的媒體上,不論是不是來自相同的資料庫。Backups performed at different times from the same or different databases can be stored on the same media. 藉由將另一個備份組附加至現有媒體的方法,就可以不影響媒體原先的內容,而在媒體最後一個備份結尾處寫入新的備份。By appending another backup set to existing media, the previous contents of the media remain intact, and the new backup is written after the end of the last backup on the media.

依預設值, SQL ServerSQL Server 一定會將新備份附加至媒體。By default, SQL ServerSQL Server always appends new backups to media. 附加只可以發生在媒體結尾。Appending can occur only at the end of the media. 例如,如果媒體磁碟區包含五個備份組,就無法跳過前三個備份組,而使用新的備份組覆寫第四個備份組。For example, if a media volume contains five backup sets, it is not possible to skip the first three backup sets to overwrite the fourth backup set with a new backup set.

如果磁帶備份採用 BACKUP WITH NOREWIND,則在作業結束後,磁帶會保持開啟狀態。If you use BACKUP WITH NOREWIND for a tape backup, the tape will be left open at the end of the operation. 這樣您就可以在磁帶上附加其他備份,否則就得將磁帶倒帶,再向前搜尋,找出最後的備份組。This allows you to append further backups to the tape without rewinding the tape and then scanning forward again to find the last backup set. 您可以在 sys.dm_io_backup_tapes 動態管理檢視中找出開啟的磁帶機清單。如需詳細資訊,請參閱 sys.dm_io_backup_tapes (Transact-SQL)You can find the list of open tape drives in the sys.dm_io_backup_tapes dynamic management view; for more information, see sys.dm_io_backup_tapes (Transact-SQL).

Microsoft Windows 備份和 SQL ServerSQL Server 備份可以共用相同的媒體,但是無法相互操作。Microsoft Windows backups and SQL ServerSQL Server backups can share the same media, but they are not interoperable. SQL ServerSQL Server 備份無法備份 Windows 資料。backup cannot back up Windows data.

重要!IMPORTANT! 壓縮和未壓縮的備份無法在媒體集中一起出現。Compressed and uncompressed backups cannot occur together in a media set. 任何 SQL Server 2008SQL Server 2008 或更新版本都可以讀取壓縮的備份。Any edition of SQL Server 2008SQL Server 2008 or later versions can read compressed backups. 如需詳細資訊,請參閱備份壓縮 (SQL Server)For more information, see Backup Compression (SQL Server).

Overwriting backup setsOverwriting backup sets

若要覆寫現有的備份組,可以使用 BACKUP 陳述式的 INIT 選項來指定。Overwriting existing backup sets is specified by using the INIT option of the BACKUP statement. 這個選項會覆寫媒體中的所有備份組,並保留媒體標頭 (如果有的話)。This option overwrites all the backup sets on the media and preserve the media header, if any. 如果沒有媒體標頭,就會加以建立。If no media header exists, one is created.

針對磁帶標頭,適當地保留標頭有其意義。For tape headers, leaving the header in place can make sense. 對於磁碟備份媒體而言,只有備份作業中指定的備份裝置所用的檔案會被覆寫,磁碟上的其他檔案則不受影響。For disk backup media, only the files used by the backup devices specified in the backup operation are overwritten; other files on the disk are unaffected. 覆寫備份時會保留任何現有的媒體標頭,而新的備份會建立為備份裝置上的第一個備份。When overwriting backups, any existing media header is preserved, and the new backup is created as the first backup on the backup device. 如果沒有現有的媒體標頭,則會自動寫入含相關媒體名稱與媒體描述的有效媒體標頭。If there is no existing media header, a valid media header with an associated media name and media description is written automatically. 如果現有的媒體標頭無效,備份作業會終止。If the existing media header is invalid, the backup operation terminates. 若為空白媒體,則會以給定的 MEDIANAME、MEDIAPASSWORD 與 MEDIADESCRIPTION (若有的話) 來產生新的媒體標頭。If the media is empty, the new media header is generated with the given MEDIANAME, MEDIAPASSWORD, and MEDIADESCRIPTION, if any.

若發生下列其中一種情況,就不會覆寫備份媒體:Backup media is not overwritten if either of the following conditions exists:

  • 媒體上的現有備份尚未到期The existing backups on the media have not expired. (若指定了 SKIP,則不會檢查到期日)。(If SKIP is specified, expiration is not checked.)

    到期日會指定備份過期的日期,之後就可以被別的備份覆寫。The expiration date specifies the date that the backup expires and can be overwritten by another backup. 建立備份時,可以指定到期日。You can specify the expiration date when a backup is created. 依預設,到期日是由 sp_configure 所設定的 media retention選項來決定。By default, the expiration date is determined by the media retention option set with sp_configure. 如需詳細資訊,請參閱本主題稍後的 sp_configure (Transact-SQL)的使用者閱讀。For more information, see sp_configure (Transact-SQL).

  • 媒體名稱 (如果提供的話) 不符合備份媒體的名稱。The media name, if provided, does not match the name on the backup media.

    媒體名稱是為了易於識別媒體而用的描述性名稱。The media name is a descriptive name used for easy identification of the media.

如果確定要覆寫現有媒體 (例如,如果知道已不再需要磁帶上的備份),就可以明確地略過這些檢查。If you are sure you want to overwrite the existing media (for example, if you know that the backups on the tape are no longer needed), you can explicitly skip these checks.

若備份媒體受到 Microsoft Windows 的密碼保護,Microsoft SQL Server 就無法寫入此媒體。If the backup media is password protected by Microsoft Windows, Microsoft SQL Server does not write to the media. 若要覆寫受到密碼保護的媒體,您必須重新初始化該媒體。To overwrite media that is password protected, you must reinitialize the media.

序號Sequence numbers

對於媒體集或媒體家族內的多個備份媒體而言,有正確的順序很重要。The correct order is important for multiple media families within a media set or multiple backup media within a media family. 因此,備份會依照下列方式指派序號:Therefore, backup assigns sequence numbers in the following ways:

  • 媒體集內的連續媒體家族Sequential media families within a media set

    媒體集內的媒體家族,會根據其在媒體集內的位置依順序編號。Within a media set, the media families are numbered sequentially according to their position in the media set. 媒體家族的編號是記錄在 backupmediafamily 資料表的 family_sequence_number 資料行中。The media-family number is recorded in the family_sequence_number column of the backupmediafamily table.

  • 媒體家族內的實體媒體Physical media within a media family

    媒體序號代表實體媒體在媒體家族內的順序。A media sequence number indicates the order of the physical media within a media family. 初始備份媒體的序號是 1。The sequence number is 1 for the initial backup media. 這會標記為 1;第二個 (第一個接續磁帶) 會標記為 2;依此類推。This is tagged with 1; the second (the first continuation tape) is tagged with 2; and so on. 在還原備份組時,媒體序號可確保還原備份的操作員以正確的順序掛載正確的媒體。When the backup set is restored, the media sequence numbers make sure that the operator restoring the backup mounts the correct media in the correct order.

多個裝置Multiple Devices

使用多個磁帶機或磁碟檔案時,需考量以下事項:When you use multiple tape drives or disk files, the following considerations apply:

  • 備份方面:For backup:

    後續的所有備份作業必須使用備份作業所建立的整個媒體集。The complete media set that is created by a backup operation must be used by all subsequent backup operations. 例如,如果使用兩個磁帶備份裝置建立媒體集,後續涉及相同媒體集的所有備份作業都必須使用兩個備份裝置。For example, if a media set was created by using two tape backup devices, all subsequent backup operations that involve the same media set must use two backup devices.

  • 還原方面:For restore:

    對磁碟備份中的任何還原以及任何線上還原而言,必須同時掛載全體媒體家族中的所有家族。For any restore from disk backups and for any online restore, all the all media families must be concurrently mounted. 若要從磁帶備份中進行離線還原,則可以較少的備份裝置處理媒體家族。For an offline restore from tape backups, you can process the media families from fewer backup devices. 對每個媒體家族而言,其處理必須先完成,另一個媒體家族的處理才會開始。Each media family must be processed completely before starting to process another media family. 媒體家族永遠會平行處理,除非是以單一裝置進行還原。Media families are always processed in parallel, unless they are being restored with a single device.

相關工作Related Tasks

建立新的媒體集Create a new media set

將新備份附加至現有媒體Append a new backup to existing media

覆寫現有備份組Overwrite existing backup sets

設定到期日Set expiration date

檢視媒體順序與家族序號View media sequence and family sequence numbers

檢視特定備份裝置上的備份組View the backup sets on a particular backup device

讀取備份裝置上媒體的媒體標頭Read the media header of the media on a backup device

另請參閱See also

SQL Server 資料庫的備份與還原 Back Up and Restore of SQL Server Databases
備份和還原期間可能發生的媒體錯誤 (SQL Server) Possible Media Errors During Backup and Restore (SQL Server)
備份記錄與標頭資訊 (SQL Server) Backup History and Header Information (SQL Server)
鏡像備份媒體集 (SQL Server) Mirrored Backup Media Sets (SQL Server)
BACKUP (Transact-SQL) BACKUP (Transact-SQL)
RESTORE (Transact-SQL) RESTORE (Transact-SQL)
RESTORE REWINDONLY (Transact-SQL) RESTORE REWINDONLY (Transact-SQL)
sp_configure (Transact-SQL)sp_configure (Transact-SQL)