备份数据库(“常规”页)Back Up Database (General 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 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.

目标Destination

“目标” 面板中的选项允许您为备份操作指定备份设备的类型,并查找现有的逻辑或物理备份设备。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)