備份資料庫 (備份選項頁面)Back Up Database (Backup Options Page)

適用於: 是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

使用 [備份資料庫] 對話方塊的 [備份選項] 頁面,即可檢視或修改資料庫備份選項。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.
開啟On 指定備份組過期而可以被覆寫的特定日期。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.

此預設值是由 [備份壓縮預設] 伺服器組態選項所設定。This default is set by the backup compression default server-configuration option. 有關如何檢視這個選項目前之設定的詳細資訊,請參閱 檢視或設定備份壓縮預設伺服器組態選項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)