介质集、介质簇和备份集 (SQL Server)Media Sets, Media Families, and Backup Sets (SQL Server)

本主题介绍 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.

备注

有关 SQL Server 备份到 Windows Azure Blob 存储服务的详细信息,请参阅 SQL Server Backup and Restore with Windows Azure Blob Storage ServiceFor more information on SQL Server backup to the Windows Azure Blob storage service,, see, SQL Server Backup and Restore with Windows Azure Blob Storage Service.

术语和定义Terms and Definitions

介质集 (media set)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)media family
在介质集中的单个非镜像设备或一组镜像设备上创建的备份。Backups created on a single nonmirrored device or a set of mirrored devices in a media set

备份集 (backup 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. “介质集” 是“备份介质” (磁带或磁盘文件,或者是 Windows Azure Blob)的有序集合,使用固定类型和数量的备份设备向其写入一个或多个备份操作。A media set is an ordered collection of backup media, tapes or disk files, or Windows Azure Blobs, to which one or more backup operations have written using a fixed type and number of backup devices. 给定介质集使用磁带机,或者使用磁盘驱动器或 Windows Azure Blob,但不能结合使用两者或以上。A given media set uses tape drives, or disk drives or Windows Azure blobs, but not a combination of two or more. 例如,与介质集关联的备份设备可能是三个名为 \\.\TAPE0\\.\TAPE1\\.\TAPE2的磁带机。For example, the 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.

备注

可以镜像介质集,以防介质卷(磁带或磁盘文件)被破坏。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).

SQL Server 2008SQL Server 2008 或更高版本可以读取压缩的备份。or later can read compressed backups. 有关详细信息,请参阅备份压缩 (SQL Server)For more information, see Backup Compression (SQL Server).

介质簇Media Families

“介质簇” 由在介质集中的单个非镜像设备或一组镜像设备上创建的备份构成。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. 有关详细信息,请参阅 使用介质集和介质簇For more information, see Using Media Sets and Families.

介质标头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.

    备注

    用于备份或还原操作的所有媒体都使用名为的标准备份格式SQL ServerSQL Server保留编写另一个应用程序的任何 MTF 介质标签,但不会写入 MTF 介质标签。All media that is used for a backup or restore operation use a standard backup format called SQL ServerSQL Server preserves any MTF media label written by another application but does not write MTF media labels.

  • MicrosoftMicrosoft 磁带格式介质标签或介质说明(自由格式文本)。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 2014SQL Server 2014 可以处理使用早期版本的 SQL ServerSQL Server设置格式的介质。can process media formatted by earlier versions of SQL ServerSQL Server.

备份集Backup Sets

成功的备份操作将向介质集中添加一个“备份集” 。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 的介质集。The following 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  

备注

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. 介质集使用了三个备份磁带,它们位于磁带机 \\.\tape0tape1tape2上。The 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

使用媒体集和介质簇Using Media Sets and Families

本节讨论使用介质集和介质簇的若干注意事项。This section discusses several considerations for using media sets and media families.

创建新介质集Creating 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 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.

重要

SQL Server 2008SQL Server 2008 或更高版本可以读取压缩的备份。or later versions can read compressed backups. 有关详细信息,请参阅备份压缩 (SQL Server)For more information, see Backup Compression (SQL Server).

覆盖备份集Overwriting Backup Sets

覆盖现有备份集是使用 BACKUP 语句的 INIT 选项指定的。Overwriting of 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.

重要

SQL Server 2012SQL Server 2012开始,MEDIAPASSWORD 选项不再可用于创建备份。Beginning with SQL Server 2012SQL Server 2012, the MEDIAPASSWORD option is discontinued for creating backups. 但仍可以还原使用密码创建的备份。However, you can still restore backups created with passwords.

存在下列任一条件时不覆盖备份介质: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

若要创建新介质集To create a new media set

若要在现有介质上追加新的备份To append a new backup to existing media

若要覆盖现有备份集To overwrite existing backup sets

若要设置的过期日期To set the expiration date

若要查看媒体序列号和簇序列号To view the media sequence and family sequence numbers

若要查看特定备份设备上的备份集To view the backup sets on a particular backup device

读取备份设备上的介质的介质标头To 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)