備份資料庫 (一般頁面)Back Up Database (General 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 General page of the Back Up Database dialog box to view or modify settings for a database back up operation.

如需基本備份概念的詳細資訊,請參閱備份概觀 (SQL Server)For more information about basic backup concepts, see Backup Overview (SQL Server).

注意

使用 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-SQL BACKUP script by clicking the Script button and then selecting a destination for the script.

若要使用 SQL Server Management Studio 建立備份To use SQL Server Management Studio to create a backup

建立部分備份To create a partial backup

  • 如需部分備份,您必須使用 Transact-SQLTransact-SQL BACKUP 陳述式搭配 PARTIAL 選項。For a partial backup, you must use the Transact-SQLTransact-SQL BACKUP statement with the PARTIAL option.

選項。Options

來源Source

[來源] 面板的選項會識別資料庫,並指定備份作業的備份類型和元件。The options of the Source panel identify the database and specify the backup type and component for the back up operation.

DatabaseDatabase
選取要備份的資料庫。Select the database to back up.

復原模式Recovery model
檢視選取的資料庫所顯示的復原模式 (SIMPLE、FULL 或 BULK_LOGGED)。View the recovery model (SIMPLE, FULL, or BULK_LOGGED) displayed for the selected database.

備份類型Backup type
選取要在指定的資料庫上執行的備份類型。Select the type of backup you want to perform on the specified database.

備份類型Backup type 可使用於Available for 限制Restrictions
完整Full 資料庫、檔案及檔案群組Databases, files, and filegroups master 資料庫上,只能使用完整備份。On the master database, only full backups are possible.

在簡單復原模式之下,檔案和檔案群組備份只可用於唯讀檔案群組。Under the Simple Recovery Model, file and filegroup backups are available only for read-only filegroups.
差異Differential 資料庫、檔案及檔案群組Databases, files, and filegroups 在簡單復原模式之下,檔案和檔案群組備份只可用於唯讀檔案群組。Under the Simple Recovery Model, file and filegroup backups are available only for read-only filegroups.
交易記錄Transaction Log 交易記錄Transaction logs 交易記錄備份無法使用於簡單復原模式。Transaction log backups are not available for the Simple Recovery Model.

只複製備份Copy Only Backup
選取此選項,即可建立只複製備份。Select to create a copy-only backup. 「只複製備份」 是與傳統 SQL ServerSQL Server 備份順序無關的 SQL ServerSQL Server 備份。A copy-only backup is a SQL ServerSQL Server backup that is independent of the sequence of conventional SQL ServerSQL Server backups. 如需詳細資訊,請參閱只複製備份 (SQL Server)For more information, see Copy-Only Backups (SQL Server).

注意

選取 [差異] 選項時,您無法建立「只複製」備份。When the Differential option is selected, you cannot create a copy-only backup.

備份元件Backup component
選取要備份的資料庫元件。Select the database component to be backed up. 如果 [備份類型] 清單中已選取 [交易記錄] ,則不會啟動此選項。If Transaction Log is selected in the Backup type list, this option is not activated.

選取下列選項按鈕之一:Select one of the following option buttons:

DatabaseDatabase 指定備份整個資料庫。Specifies that the entire database be backed up.
檔案與檔案群組Files and filegroups 指定備份指定的檔案和 (或) 檔案群組。Specifies that the specified files and/or filegroups be backed up.

選取這個選項會開啟 [選取檔案與檔案群組] 對話方塊。Selecting this option, opens the Select Files and Filegroups dialog box. 在選取了要備份的檔案群組或檔案,並按一下 [確定] 之後,選取項目就會出現在 [檔案群組與檔案] 方塊中。After you select the filegroups or files you want to back up and click Ok, your selections appear in the Filegroups and files box.

DestinationDestination

[目的地] 面板的選項可讓您指定備份作業的備份裝置類型,並尋找現有的邏輯或實體備份裝置。The options of the Destination panel allow for you to specify the type of backup device for the back up operation and find an existing logical or physical backup device.

注意

如需 SQL ServerSQL Server 備份裝置的相關資訊,請參閱備份裝置 (SQL Server)For information about SQL ServerSQL Server backup devices, see Backup Devices (SQL Server).

備份至Back up to
選取下列要備份之媒體類型的其中之一。Select one of the following types of media to which to back up. 您選取的目的地會出現在 [備份至] 清單中。The destinations you select appear in the Back up to list.

磁碟Disk 備份至磁碟。Backs up to disk. 這可能是針對資料庫所建立的系統檔案,或以磁碟為基礎的邏輯備份裝置。This may be a system file or a disk-based logical backup device created for the database. 目前選取的磁碟會出現在 [備份至] 清單中。The currently selected disks appear in the Back up to list. 您最多可以為備份作業選取 64 個磁碟裝置。You can select up to 64 disk devices for your backup operation.
磁帶Tape 備份至磁帶。Backs up to tape. 這可能是針對資料庫所建立的本機磁帶機,或以磁帶為基礎的邏輯備份裝置。This may be a local tape drive or a tape-based logical backup device created for the database. 目前選取的磁帶會出現在 [備份至] 清單中。The currently selected tapes appear in the Back up to list. 最大數目是 64。The maximum number is 64. 如果伺服器上沒有附加磁帶裝置,則會停用此選項。If there are no tape devices attached to the server, this option is deactivated. 您選取的磁帶會列在 [備份至] 清單中。The tapes you select are listed in the Back up to list.

注意:未來的 SQL ServerSQL Server版本中將會移除磁帶備份裝置的支援。Note: Support for tape backup devices will be removed in a future version of SQL ServerSQL Server. 請避免在新的開發工作中使用這項功能,並規劃修改目前使用這項功能的應用程式。Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
URLURL 備份至 Microsoft Azure Blob 儲存體。Backs up to Microsoft Azure Blob storage.

所顯示的下一組選項取決於選取的目的地類型。The next set of options displayed depends on the type of destination selected. 如果選取 [磁碟] 或 [磁帶],則會顯示下列選項。If you select Disk or Tape, the following options are displayed.

加入Add
將檔案或裝置加入至 [備份至] 清單。Adds a file or device to the Back up to list. 您在本機磁碟或遠端磁碟上,最多可以同時備份到 64 個裝置。You can back up to 64 devices simultaneously on a local disk or remote disk. 若要指定遠端磁碟上的檔案,請使用完整的通用命名慣例 (UNC) 名稱。To specify a file on a remote disk, use the fully qualified universal naming convention (UNC) name. 如需詳細資訊,請參閱 備份裝置 (SQL Server)執行個體上建立資料庫備份,就需要這個選項。For more information, see Backup Devices (SQL Server).

移除Remove
[備份至] 清單中,移除一個或多個目前選取的裝置。Removes one or more currently selected devices from the Back up to list.

ContentsContents
顯示所選裝置的媒體內容 (如果裝置存在)。Displays the media contents for the selected device if it exists. URL 指定時,按鈕不會執行函數。The button does not perform a function when a URL is specified.

[選取備份目的地] 對話方塊:在您選取 [新增] 之後,[選取備份目的地] 對話方塊隨即出現。Select Backup Destination dialog box The Select Backup Destination dialog box appears after you select Add. 所顯示的選項集取決於選取的目的地類型。The set of options displayed depends on the type of destination selected.

如果選取 磁碟磁帶 作為備份目的地,則會顯示下列選項。If you selected Disk or Tape as the backup destination, the following option is displayed.

* 檔案名稱File Name
指定備份檔案的名稱。Specify the name of the backup file.

如果選取 URL 作為備份目的地,則會顯示下列選項:If you selected URL as the backup destination, the following options are displayed: * Azure 儲存體容器Azure storage container
儲存備份檔案的 Microsoft Azure 儲存體容器名稱。The name of the Microsoft Azure storage container to store the backup files.

* 共用的存取原則:Shared Access Policy:
輸入手動輸入之容器的共用存取簽章。Enter the shared access signature for a manually entered container. 如果已選擇現有的容器,則此欄位無法使用。This field is not available if an existing container was chosen.

* 備份檔案:Backup File:
備份檔案的名稱。Name of the backup file.

* 新增容器:New Container:
用來註冊您沒有共用存取簽章的現有容器。Used to register an existing container that you do not have a shared access signature for. 請參閱 連接到 Microsoft Azure 訂用帳戶See Connect to a Microsoft Azure Subscription.

另請參閱See Also

備份交易記錄 (SQL Server) Back Up a Transaction Log (SQL Server)
備份檔案和檔案群組 (SQL Server) Back Up Files and Filegroups (SQL Server)
定義磁碟檔案的邏輯備份裝置 (SQL Server) Define a Logical Backup Device for a Disk File (SQL Server)
定義磁帶機的邏輯備份裝置 (SQL Server) Define a Logical Backup Device for a Tape Drive (SQL Server)
復原模式 (SQL Server)Recovery Models (SQL Server)