备份数据库(“备份选项”页)Back Up Database (Backup Options Page)

适用对象:是SQL Server 否Azure SQL 数据库 否Azure Synapse Analytics (SQL DW) 否并行数据仓库 APPLIES TO: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

使用 “备份数据库” 对话框的 “备份选项” 页可以查看或修改数据库备份选项。Use the Backup Options page of the Back Up Database dialog box to view or modify database backup options.

使用 SQL Server Management Studio 创建备份To create a backup by using SQL Server Management Studio

重要

可以定义用于创建数据库备份的数据库维护计划。You can define a database maintenance plan to create database backups. 有关详细信息,请参阅维护计划使用维护计划向导For more information, see Maintenance Plans and Use the Maintenance Plan Wizard.

备注

使用 SQL Server Management StudioSQL Server Management Studio 指定备份任务时,可以通过单击“脚本”Transact-SQLTransact-SQL按钮,再为脚本选择一个目标,生成对应的 BACKUP 脚本。When you specify a backup task by using SQL Server Management StudioSQL Server Management Studio, you can generate the corresponding Transact-SQLTransact-SQLBACKUP script by clicking the Script button and then selecting a destination for the script.

选项Options

备份集Backup set

“备份集” 面板中的选项允许您指定有关备份操作所创建的备份集的可选信息。The options of the Backup set panel allow for you to specify optional information about the backup set created by the back up operation.

名称Name
指定备份集名称。Specify the backup set name. 系统将根据数据库名称和备份类型自动建议一个默认名称。The system automatically suggests a default name based on the database name and the backup type.

有关备份集的信息,请参阅媒体集、媒体簇和备份集 (SQL Server)For information about backup sets, see Media Sets, Media Families, and Backup Sets (SQL Server).

说明Description
输入备份集的说明。Enter a description of the backup set.

备份集过期时间Backup set will expire
选择以下过期选项之一:Choose one of the following expiration options. 如果选择 “URL” 作为备份目标,则禁用此选项。This option is disabled if URL is chosen as the backup destination.

之后After 指定在多少天后此备份集才会过期,从而可被覆盖。Specify the number of days that must elapse before this backup set expires and can be overwritten. 此值范围为 0 到 99999 天;0 天表示备份集将永不过期。This value can be from 0 to 99999 days; a value of 0 days means that the backup set will never expire.

备份过期时间的默认值是在“默认备份介质保持期(天)” 选项中设置的值。The default value for backup expiration is the value set in the Default backup media retention (in days) option. 若要访问此选项,请在对象资源管理器中右键单击服务器名称,再选择 “属性”;然后,单击 “服务器属性”对话框的 “数据库设置”页。To access this, right-click the server name in Object Explorer and select Properties; then click the Database Settings page of the Server Properties dialog box.
OnOn 指定备份集过期从而可被覆盖的具体日期。Specify a specific date when the backup set expires and can be overwritten.

压缩Compression

SQL Server 2008 EnterpriseSQL Server 2008 Enterprise (或更高版本)支持 备份压缩(or a later version) supports backup compression.

设置备份压缩Set backup compression
SQL Server 2008 EnterpriseSQL Server 2008 Enterprise (或更高版本)中,选择以下备份压缩值之一:In SQL Server 2008 EnterpriseSQL Server 2008 Enterprise (or a later version), select one of the following backup compression values:

使用默认服务器设置Use the default server setting 单击此选项可使用服务器级别默认值。Click to use the server-level default.

此默认值可通过 backup compression default 服务器配置选项进行设置。This default is set by the backup compression default server-configuration option. 有关如何查看此选项当前设置的信息,请参阅 查看或配置 backup compression default 服务器配置选项For information about how to view the current setting of this option, see View or Configure the backup compression default Server Configuration Option.
压缩备份Compress backup 单击此选项可压缩备份,而不考虑服务器级别默认值。Click to compress the backup, regardless of the server-level default.

** 重要提示 ** 默认情况下,压缩会大大提高 CPU 使用率,但压缩进程占用的额外 CPU 可能会对并发操作造成不利影响。** Important ** By default, compression significantly increases CPU usage, and the additional CPU consumed by the compression process might adversely impact concurrent operations. 因此,你可能需要在会话中创建低优先级的压缩备份,其 CPU 使用率受 资源调控器限制。Therefore, you might want to create low-priority compressed backups in a session whose CPU usage is limited by Resource Governor. 有关详细信息,请参阅本主题后面的 使用资源调控器限制备份压缩的 CPU 使用量 (Transact-SQL)限制。For more information, see Use Resource Governor to Limit CPU Usage by Backup Compression (Transact-SQL).
不压缩备份Do not compress backup 单击此选项可创建未压缩的备份,而不考虑服务器级别默认值。Click to create an uncompressed backup, regardless of the server-level default.

加密Encryption

若要创建加密的备份,请选中 “加密备份” 复选框。To create an encrypted backup, check the Encrypt backup check box. 选择要用于加密步骤的加密算法,然后从现有证书或非对称密钥的列表中提供一个证书或非对称密钥。Select an encryption algorithm to use for the encryption step, and provide a Certificate or Asymmetric key from a list of existing certificates or asymmetric keys. 可用于加密的算法是:The available algorithms for encryption are:

  • AES 128AES 128

  • AES 192AES 192

  • AES 256AES 256

  • 三重 DESTriple DES

提示

如果您选择了追加到现有备份集,则禁用加密选项。The encryption option is disabled if you selected to append to existing backup set.

建议做法是备份证书或密钥,而存储它们的位置要与所加密的备份不同。It is recommended practice to back up your certificate or keys and store them in a different location than the backup you encrypted.

仅支持位于可扩展密钥管理 (EKM) 中的密钥。Only keys residing in the Extensible Key Management (EKM) are supported.

另请参阅See Also

BACKUP (Transact-SQL) BACKUP (Transact-SQL)
备份事务日志 (SQL Server) Back Up a Transaction Log (SQL Server)
备份文件和文件组 (SQL Server) Back Up Files and Filegroups (SQL Server)
在数据库损坏时备份事务日志 (SQL Server)Back Up the Transaction Log When the Database Is Damaged (SQL Server)