RESTORE 陳述式 - HEADERONLY (Transact-SQL)RESTORE Statements - HEADERONLY (Transact-SQL)

適用於: 是SQL Server 是Azure SQL Database (僅限受控執行個體) 否Azure Synapse Analytics (SQL DW) 否平行處理資料倉儲 APPLIES TO: yesSQL Server yesAzure SQL Database (Managed Instance only) noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

傳回 SQL ServerSQL Server 中含有特定備份裝置上的所有備份組之所有備份標頭資訊的結果集。Returns a result set containing all the backup header information for all backup sets on a particular backup device in SQL ServerSQL Server.

注意

如需引數的描述,請參閱 RESTORE 引數 (Transact-SQL)For the descriptions of the arguments, see RESTORE Arguments (Transact-SQL).

主題連結圖示 Transact-SQL 語法慣例Topic link icon Transact-SQL Syntax Conventions

語法Syntax

  
RESTORE HEADERONLY   
FROM <backup_device>   
[ WITH   
 {  
--Backup Set Options  
   FILE = { backup_set_file_number | @backup_set_file_number }   
 | PASSWORD = { password | @password_variable }   
  
--Media Set Options  
 | MEDIANAME = { media_name | @media_name_variable }   
 | MEDIAPASSWORD = { mediapassword | @mediapassword_variable }  
  
--Error Management Options  
 | { CHECKSUM | NO_CHECKSUM }   
 | { STOP_ON_ERROR | CONTINUE_AFTER_ERROR }  
  
--Tape Options  
 | { REWIND | NOREWIND }   
 | { UNLOAD | NOUNLOAD }    
 } [ ,...n ]  
]  
[;]  
  
<backup_device> ::=  
{   
   { logical_backup_device_name |  
      @logical_backup_device_name_var }  
   | { DISK | TAPE | URL } = { 'physical_backup_device_name' |  
       @physical_backup_device_name_var }   
}  
  

注意

URL 是用來指定 Microsoft Azure Blob 儲存體位置和檔案名稱的格式,從 SQL Server 2012 (11.x)SQL Server 2012 (11.x) SP1 CU2 開始支援。URL is the format used to specify the location and the file name for Microsoft Azure Blob Storage and is supported starting with SQL Server 2012 (11.x)SQL Server 2012 (11.x) SP1 CU2. 雖然 Microsoft Azure 儲存體是一項服務,但其實作方式類似於磁碟和磁帶,以便為這三種裝置提供一致且順暢的還原體驗。Although Microsoft Azure storage is a service, the implementation is similar to disk and tape to allow for a consistent and seamless restore experience for all the three devices.

引數Arguments

如需 RESTORE HEADERONLY 引數的描述,請參閱 RESTORE 引數 (Transact-SQL)For descriptions of the RESTORE HEADERONLY arguments, see RESTORE Arguments (Transact-SQL).

結果集Result Sets

對於給定裝置中的每個備份,伺服器都會傳送一個含有下列資料行的標頭資訊資料列:For each backup on a given device, the server sends a row of header information with the following columns:

注意

RESTORE HEADERONLY 會查看媒體中的所有備份組。RESTORE HEADERONLY looks at all backup sets on the media. 因此,當使用高容量磁帶機時,產生這個結果集可能需要一些時間。Therefore, producing this result set when using high-capacity tape drives can take some time. 若要快速瀏覽媒體,而不需要取得每個備份組的相關資訊,請使用 RESTORE LABELONLY 或指定 FILE = backup_set_file_numberTo get a quick look at the media without getting information about every backup set, use RESTORE LABELONLY or specify FILE = backup_set_file_number.

注意

由於 MicrosoftMicrosoft Tape Format 本質的緣故,來自其他軟體程式的備份組有可能佔用與 MicrosoftMicrosoftSQL ServerSQL Server 備份組相同媒體上的空間。Due to the nature of MicrosoftMicrosoft Tape Format, it is possible for backup sets from other software programs to occupy space on the same media as MicrosoftMicrosoftSQL ServerSQL Server backup sets. RESTORE HEADERONLY 傳回的結果集會針對每個這些其他備份組,各包括一個資料列。The result set returned by RESTORE HEADERONLY includes a row for each of these other backup sets.

資料行名稱Column name 資料類型Data type SQL Server 備份組的描述Description for SQL Server backup sets
BackupNameBackupName nvarchar(128)nvarchar(128) 備份組名稱Backup set name.
BackupDescriptionBackupDescription nvarchar(255)nvarchar(255) 備份組描述Backup set description.
BackupTypeBackupType smallintsmallint 備份類型:Backup type:

1 = 資料庫1 = Database

2 = 交易記錄2 = Transaction log

4 = 檔案4 = File

5 = 差異資料庫5 = Differential database

6 = 差異檔案6 = Differential file

7 = 部分7 = Partial

8 = 差異部分8 = Differential partial
ExpirationDateExpirationDate datetimedatetime 備份組的到期日。Expiration date for the backup set.
CompressedCompressed BYTE(1)BYTE(1) 是否利用以軟體為基礎的壓縮來壓縮備份組:Whether the backup set is compressed using software-based compression:

0 = 否0 = No

1 = 是1 = Yes
位置Position smallintsmallint 備份組在磁碟區中的位置 (用來搭配 FILE = 選項)。Position of the backup set in the volume (for use with the FILE = option).
DeviceTypeDeviceType tinyinttinyint 備份作業所用裝置的對應號碼。Number corresponding to the device used for the backup operation.

磁碟:Disk:

2 = 邏輯2 = Logical

102 = 實體102 = Physical

磁帶:Tape:

5 = 邏輯5 = Logical

105 = 實體105 = Physical

虛擬裝置:Virtual Device:

7 = 邏輯7 = Logical

107 = 實體107 = Physical

邏輯裝置名稱和裝置號碼在 sys.backup_devices 中;如需詳細資訊,請參閱 sys.backup_devices (Transact-SQL)Logical device names and device numbers are in sys.backup_devices; for more information, see sys.backup_devices (Transact-SQL).
UserNameUserName nvarchar(128)nvarchar(128) 執行備份作業的使用者名稱。User name that performed the backup operation.
ServerNameServerName nvarchar(128)nvarchar(128) 寫入備份組的伺服器名稱。Name of the server that wrote the backup set.
DatabaseNameDatabaseName nvarchar(128)nvarchar(128) 備份的資料庫名稱。Name of the database that was backed up.
DatabaseVersionDatabaseVersion intint 建立備份的來源資料庫版本。Version of the database from which the backup was created.
DatabaseCreationDateDatabaseCreationDate datetimedatetime 建立資料庫的日期和時間。Date and time the database was created.
BackupSizeBackupSize numeric(20,0)numeric(20,0) 備份的大小 (以位元組為單位)。Size of the backup, in bytes.
FirstLSNFirstLSN numeric(25,0)numeric(25,0) 備份組中第一個記錄的記錄序號。Log sequence number of the first log record in the backup set.
LastLSNLastLSN numeric(25,0)numeric(25,0) 備份組之後下一個記錄檔記錄的記錄序號。Log sequence number of the next log record after the backup set.
CheckpointLSNCheckpointLSN numeric(25,0)numeric(25,0) 在建立備份時,最近的檢查點之記錄序號。Log sequence number of the most recent checkpoint at the time the backup was created.
DatabaseBackupLSNDatabaseBackupLSN numeric(25,0)numeric(25,0) 最近的完整資料庫備份之記錄序號。Log sequence number of the most recent full database backup.

DatabaseBackupLSN 是備份啟動時所觸發的「檢查點起點」。DatabaseBackupLSN is the "begin of checkpoint" that is triggered when the backup starts. 如果備份是在資料庫閒置時進行的,且沒有設定任何複寫,這個 LSN 就會與 FirstLSN 一致。This LSN will coincide with FirstLSN if the backup is taken when the database is idle and no replication is configured.
BackupStartDateBackupStartDate datetimedatetime 備份作業開始的日期和時間。Date and time that the backup operation began.
BackupFinishDateBackupFinishDate datetimedatetime 備份作業完成的日期和時間。Date and time that the backup operation finished.
SortOrderSortOrder smallintsmallint 伺服器排序順序。Server sort order. 這個資料行只對資料庫備份有效。This column is valid for database backups only. 提供這個項目的目的,是為了與舊版相容。Provided for backward compatibility.
CodePageCodePage smallintsmallint 伺服器所用的伺服器字碼頁或字元集。Server code page or character set used by the server.
UnicodeLocaleIdUnicodeLocaleId intint 用來排序 Unicode 字元資料的伺服器 Unicode 地區設定識別碼組態選項。Server Unicode locale ID configuration option used for Unicode character data sorting. 提供這個項目的目的,是為了與舊版相容。Provided for backward compatibility.
UnicodeComparisonStyleUnicodeComparisonStyle intint 伺服器 Unicode 比較樣式組態選項,用來提供其他 Unicode 資料排序控制。Server Unicode comparison style configuration option, which provides additional control over the sorting of Unicode data. 提供這個項目的目的,是為了與舊版相容。Provided for backward compatibility.
CompatibilityLevelCompatibilityLevel tinyinttinyint 建立備份的來源資料庫相容性層級設定。Compatibility level setting of the database from which the backup was created.
SoftwareVendorIdSoftwareVendorId intint 軟體供應商識別碼。Software vendor identification number. 就 SQL Server 而言,這個號碼是 4608 (或十六進位的 0x1200)。For SQL Server, this number is 4608 (or hexadecimal 0x1200).
SoftwareVersionMajorSoftwareVersionMajor intint 建立備份組的伺服器之主要版本號碼。Major version number of the server that created the backup set.
SoftwareVersionMinorSoftwareVersionMinor intint 建立備份組的伺服器之次要版本號碼。Minor version number of the server that created the backup set.
SoftwareVersionBuildSoftwareVersionBuild intint 建立備份組的伺服器之組建編號。Build number of the server that created the backup set.
MachineNameMachineName nvarchar(128)nvarchar(128) 執行備份作業的電腦名稱。Name of the computer that performed the backup operation.
旗標Flags intint 若設為 1,個別旗標位元意義如下:Individual flags bit meanings if set to 1:

1 = 記錄備份包含大量記錄作業。1 = Log backup contains bulk-logged operations.

2 = 快照集備份。2 = Snapshot backup.

4 = 備份時,資料庫是唯讀的。4 = Database was read-only when backed up.

8 = 備份時,資料庫處於單一使用者模式。8 = Database was in single-user mode when backed up.

16 = 備份包含備份總和檢查碼。16 = Backup contains backup checksums.

32 = 備份時,資料庫損毀,但要求備份作業忽略錯誤並繼續執行。32 = Database was damaged when backed up, but the backup operation was requested to continue despite errors.

64 = 結尾記錄備份。64 = Tail log backup.

128 = 含不完整中繼資料的結尾記錄備份。128 = Tail log backup with incomplete metadata.

256 = 使用 NORECOVERY 來進行的結尾記錄備份。256 = Tail log backup with NORECOVERY.

重要: 建議您不要使用 Flags,請改用個別的布林資料行 (下列從 HasBulkLoggedDataIsCopyOnly 的布林資料行)。Important: We recommend that instead of Flags you use the individual Boolean columns (listed below starting with HasBulkLoggedData and ending with IsCopyOnly).
BindingIDBindingID uniqueidentifieruniqueidentifier 資料庫的繫結識別碼。Binding ID for the database. 這會對應到 sys.database_recovery_status database_guidThis corresponds to sys.database_recovery_status database_guid. 當還原資料庫時,會指派一個新值。When a database is restored, a new value is assigned. 另請參閱 FamilyGUID (下方)。Also see FamilyGUID (below).
RecoveryForkIDRecoveryForkID uniqueidentifieruniqueidentifier 結尾復原分岔的識別碼。ID for the ending recovery fork. 這個資料行會與 backupset 資料表中的 last_recovery_fork_guid對應。This column corresponds to last_recovery_fork_guid in the backupset table.

就資料備份而言,RecoveryForkID 等於 FirstRecoveryForkIDFor data backups, RecoveryForkID equals FirstRecoveryForkID.
定序Collation nvarchar(128)nvarchar(128) 資料庫所用的定序。Collation used by the database.
FamilyGUIDFamilyGUID uniqueidentifieruniqueidentifier 在建立之時,原始資料庫的識別碼。ID of the original database when created. 當還原資料庫時,這個值會維持不變。This value stays the same when the database is restored.
HasBulkLoggedDataHasBulkLoggedData bitbit 1 = 包含大量記錄作業的記錄備份。1 = Log backup containing bulk-logged operations.
IsSnapshotIsSnapshot bitbit 1 快照集備份。1 = Snapshot backup.
IsReadOnlyIsReadOnly bitbit 1 = 備份時,資料庫是唯讀的。1 = Database was read-only when backed up.
IsSingleUserIsSingleUser bitbit 1 = 備份時,資料庫是單一使用者。1 = Database was single-user when backed up.
HasBackupChecksumsHasBackupChecksums bitbit 1 = 備份包含備份總和檢查碼。1 = Backup contains backup checksums.
IsDamagedIsDamaged bitbit 1 = 備份時,資料庫損毀,但要求備份作業忽略錯誤並繼續執行。1 = Database was damaged when backed up, but the backup operation was requested to continue despite errors.
BeginsLogChainBeginsLogChain bitbit 1 = 這是連續記錄備份鏈結中的第一個記錄備份。1 = This is the first in a continuous chain of log backups. 記錄鏈結的開頭是建立資料庫之後,或從簡單復原模式切換到完整或大量記錄復原模式之後,所取出的第一個記錄備份。A log chain begins with the first log backup taken after the database is created or when it is switched from the Simple to the Full or Bulk-Logged Recovery Model.
HasIncompleteMetaDataHasIncompleteMetaData bitbit 1 = 含不完整中繼資料的結尾記錄備份。1 = A tail-log backup with incomplete meta-data.

如需有關含不完整備份中繼資料之結尾記錄備份的資訊,請參閱結尾記錄備份 (SQL Server)For information about tail-log backups with incomplete backup metadata, see Tail-Log Backups (SQL Server).
IsForceOfflineIsForceOffline bitbit 1 = 使用 NORECOVERY 來進行的備份;資料庫因備份而離線。1 = Backup taken with NORECOVERY; the database was taken offline by backup.
IsCopyOnlyIsCopyOnly bitbit 1 = 僅限複製的備份。1 = A copy-only backup.

僅限複製備份並不會影響資料庫的整體備份和還原程序。A copy-only backup does not impact the overall backup and restore procedures for the database. 如需詳細資訊,請參閱只複製備份 (SQL Server)For more information, see Copy-Only Backups (SQL Server).
FirstRecoveryForkIDFirstRecoveryForkID uniqueidentifieruniqueidentifier 起始復原分岔的識別碼。ID for the starting recovery fork. 這個資料行會與 backupset 資料表中的 first_recovery_fork_guid對應。This column corresponds to first_recovery_fork_guid in the backupset table.

就資料備份而言,FirstRecoveryForkID 等於 RecoveryForkIDFor data backups, FirstRecoveryForkID equals RecoveryForkID.
ForkPointLSNForkPointLSN numeric(25,0) NULLnumeric(25,0) NULL 如果 FirstRecoveryForkID 不等於 RecoveryForkID,這就是分岔點的記錄序號。If FirstRecoveryForkID is not equal to RecoveryForkID, this is the log sequence number of the fork point. 否則,這個值是 NULL。Otherwise, this value is NULL.
RecoveryModelRecoveryModel nvarchar(60)nvarchar(60) 這是資料庫的復原模式,它有下列幾種:Recovery model for the Database, one of:

FULLFULL

BULK-LOGGEDBULK-LOGGED

SIMPLESIMPLE
DifferentialBaseLSNDifferentialBaseLSN numeric(25,0) NULLnumeric(25,0) NULL 如果是單一基底差異備份,這個值就等於差異基底的 FirstLSN;LSN 大於或等於 DifferentialBaseLSN 的變更會納入差異備份中。For a single-based differential backup, the value equals the FirstLSN of the differential base; changes with LSNs greater than or equal to DifferentialBaseLSN are included in the differential.

如果是多重基底差異備份,這個值就是 NULL,基底 LSN 必須取決於檔案層級。For a multi-based differential, the value is NULL, and the base LSN must be determined at the file level. 如需詳細資訊,請參閱 RESTORE FILELISTONLY (Transact-SQL)For more information, see RESTORE FILELISTONLY (Transact-SQL).

如果是非差異備份類型,這個值一律是 NULL。For non-differential backup types, the value is always NULL.

如需詳細資訊,請參閱 差異備份 (SQL Server)For more information, see Differential Backups (SQL Server).
DifferentialBaseGUIDDifferentialBaseGUID uniqueidentifieruniqueidentifier 如果是單一基底差異備份,這個值就是差異基底的唯一識別碼。For a single-based differential backup, the value is the unique identifier of the differential base.

如果是多重基底差異備份,這個值就是 NULL,差異基底必須取決於個別檔案。For multi-based differentials, the value is NULL, and the differential base must be determined per file.

如果是非差異備份類型,這個值就是 NULL。For non-differential backup types, the value is NULL.
BackupTypeDescriptionBackupTypeDescription nvarchar(60)nvarchar(60) 這是字串備份類型,它有下列幾種:Backup type as string, one of:

DATABASEDATABASE

TRANSACTION LOGTRANSACTION LOG

FILE OR FILEGROUPFILE OR FILEGROUP

DATABASE DIFFERENTIALDATABASE DIFFERENTIAL

FILE DIFFERENTIAL PARTIALFILE DIFFERENTIAL PARTIAL

PARTIAL DIFFERENTIALPARTIAL DIFFERENTIAL
BackupSetGUIDBackupSetGUID uniqueidentifier NULLuniqueidentifier NULL 在媒體中,用來識別備份組的唯一識別碼。Unique identification number of the backup set, by which it is identified on the media.
CompressedBackupSizeCompressedBackupSize bigintbigint 備份組的位元組計數。Byte count of the backup set. 就未壓縮的備份而言,這個值會與 BackupSize 相同。For uncompressed backups, this value is the same as BackupSize.

若要計算壓縮比,請使用 CompressedBackupSizeBackupSizeTo calculate the compression ratio, use CompressedBackupSize and BackupSize.

msdb 升級期間,這個值會設定為符合 BackupSize 資料行的值。During an msdb upgrade, this value is set to match the value of the BackupSize column.
containmentcontainment tinyint not NULLtinyint not NULL 適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.

指示資料庫的內含項目狀態。Indicates the containment status of the database.

0 = 資料庫內含項目已關閉0 = database containment is off

1 = 資料庫內含項目是部分1 = database is in partial containment
KeyAlgorithmKeyAlgorithm nvarchar(32)nvarchar(32) 適用於SQL ServerSQL Server (SQL Server 2014 (12.x)SQL Server 2014 (12.x) (CU1) 至目前的版本)。Applies to: SQL ServerSQL Server (SQL Server 2014 (12.x)SQL Server 2014 (12.x) (CU1) through current version.

用於加密備份的加密演算法。The encryption algorithm used to encrypt the backup. NO_Encryption 表示備份未加密。NO_Encryption indicates that the backup was not encrypted. 無法判斷正確的值時,該值應該是 NULL。When the correct value cannot be determined the value should be NULL.
EncryptorThumbprintEncryptorThumbprint varbinary(20)varbinary(20) 適用於SQL ServerSQL Server (SQL Server 2014 (12.x)SQL Server 2014 (12.x) (CU1) 至目前的版本)。Applies to: SQL ServerSQL Server (SQL Server 2014 (12.x)SQL Server 2014 (12.x) (CU1) through current version.

加密程式指模,可用來尋找資料庫中的憑證或非對稱金鑰。The thumbprint of the encryptor which can be used to find certificate or the asymmetric key in the database. 備份未加密時,這個值會是 NULL。When the backup was not encrypted, this value is NULL.
EncryptorTypeEncryptorType nvarchar(32)nvarchar(32) 適用於SQL ServerSQL Server (SQL Server 2014 (12.x)SQL Server 2014 (12.x) (CU1) 至目前的版本)。Applies to: SQL ServerSQL Server (SQL Server 2014 (12.x)SQL Server 2014 (12.x) (CU1) through current version.

使用的加密程式類型:憑證或非對稱金鑰。The type of encryptor used: Certificate or Asymmetric Key. 備份未加密時,這個值會是 NULL。When the backup was not encrypted, this value is NULL.

注意

如果定義了備份組的密碼,RESTORE HEADERONLY 只會顯示密碼符合命令指定的 PASSWORD 選項的備份組。If passwords are defined for the backup sets, RESTORE HEADERONLY shows complete information for only the backup set whose password matches the specified PASSWORD option of the command. 另外,RESTORE HEADERONLY 也只會顯示未受保護之備份組的完整資訊。RESTORE HEADERONLY also shows complete information for unprotected backup sets. 媒體上其他受密碼保護之備份組的 BackupName 資料行會設為 ' Password Protected ',所有其他資料行則為 NULL。The BackupName column for the other password-protected backup sets on the media is set to 'Password Protected', and all other columns are NULL.

一般備註General Remarks

用戶端可以利用 RESTORE HEADERONLY 來擷取特定備份裝置上的所有備份之所有備份標頭資訊。A client can use RESTORE HEADERONLY to retrieve all the backup header information for all backups on a particular backup device. 對於備份裝置中的每個備份,伺服器會將標頭資訊當做一個資料列來傳送。For each backup on the backup device, the server sends the header information as a row.

SecuritySecurity

備份作業可以選擇性地指定媒體集的密碼及 (或) 備份組的密碼。A backup operation may optionally specify passwords for a media set, a backup set, or both. 當在媒體集或備份組上定義密碼時,您必須在 RESTORE 陳述式中,指定一個或多個正確的密碼。When a password has been defined on a media set or backup set, you must specify the correct password or passwords in the RESTORE statement. 這些密碼可以防止他人利用 MicrosoftMicrosoft SQL ServerSQL Server 工具,在未經授權的情況下,對媒體執行還原作業及附加備份組。These passwords prevent unauthorized restore operations and unauthorized appends of backup sets to media using MicrosoftMicrosoft SQL ServerSQL Server tools. 不過,密碼無法防止使用者利用 BACKUP 陳述式的 FORMAT 選項來覆寫媒體。However, a password does not prevent overwrite of media using the BACKUP statement's FORMAT option.

重要

這個密碼所提供的保護很弱。The protection provided by this password is weak. 這是為了防止已獲授權或未獲授權的使用者使用 SQL ServerSQL Server 工具進行不正確的還原。It is intended to prevent an incorrect restore using SQL ServerSQL Server tools by authorized or unauthorized users. 它無法防止透過其他方式或以取代密碼的方式來讀取備份資料。It does not prevent the reading of the backup data by other means or the replacement of the password. 這項功能處於維護模式,並可能在 Microsoft SQL Server 的未來版本中移除。This feature is in maintenance mode and may be removed in a future version of Microsoft SQL Server. 請避免在新的開發工作中使用這項功能,並規劃修改目前使用這項功能的應用程式。Avoid using this feature in new development work, and plan to modify applications that currently use this feature.保護備份的最佳做法是將備份磁帶存放在安全位置,或備份至受適當存取控制清單 (ACL) 保護的磁碟檔案中。The best practice for protecting backups is to store backup tapes in a secure location or back up to disk files that are protected by adequate access control lists (ACLs). ACL 應該設在備份建立所在的根目錄下。The ACLs should be set on the directory root under which backups are created.

權限Permissions

取得有關備份組或備份裝置的資訊需要 CREATE DATABASE 權限。Obtaining information about a backup set or backup device requires CREATE DATABASE permission. 如需詳細資訊,請參閱 GRANT 資料庫權限 (Transact-SQL)For more information, see GRANT Database Permissions (Transact-SQL).

範例Examples

下列範例會傳回磁碟檔 C:\AdventureWorks-FullBackup.bak 標頭中的資訊。The following example returns the information in the header for the disk file C:\AdventureWorks-FullBackup.bak.

RESTORE HEADERONLY   
FROM DISK = N'C:\AdventureWorks-FullBackup.bak'   
WITH NOUNLOAD;  
GO  

另請參閱See Also

BACKUP (Transact-SQL) BACKUP (Transact-SQL)
backupset (Transact-SQL) backupset (Transact-SQL)
RESTORE REWINDONLY (Transact-SQL) RESTORE REWINDONLY (Transact-SQL)
RESTORE VERIFYONLY (Transact-SQL) RESTORE VERIFYONLY (Transact-SQL)
RESTORE (Transact-SQL) RESTORE (Transact-SQL)
備份記錄與標頭資訊 (SQL Server) Backup History and Header Information (SQL Server)
在備份或還原期間啟用或停用備份總和檢查碼 (SQL Server) Enable or Disable Backup Checksums During Backup or Restore (SQL Server)
媒體集、媒體家族與備份組 (SQL Server) Media Sets, Media Families, and Backup Sets (SQL Server)
復原模式 (SQL Server)Recovery Models (SQL Server)