日志传送事务日志备份设置Log Shipping Transaction Log Backup Settings

适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) 适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions)

使用此对话框可以配置和修改日志传送配置的事务日志备份设置。Use this dialog box to configure and modify the transaction log backup settings for a log shipping configuration.

有关日志传送概念的说明,请参阅 关于日志传送 (SQL Server)For an explanation of log shipping concepts, see About Log Shipping (SQL Server).

选项Options

备份文件夹的网络路径Network path to the backup folder
在此框中键入备份文件夹的网络共享位置。Type the network share to your backup folder in this box. 用于保存事务日志备份的本地文件夹必须处于共享状态,以便日志传送复制作业可以将这些文件复制到辅助服务器。The local folder where your transaction log backups are saved must be shared so that the log shipping copy jobs can copy these files to the secondary server. 必须向代理帐户授予此网络共享的读取权限,复制作业将在辅助服务器实例上的该帐户下运行。You must grant read permissions on this network share to the proxy account under which the copy job will run at the secondary server instance. 默认情况下,这是辅助服务器实例的 SQLServerAgent 服务帐户,但是管理员可以为该作业选择另一个代理帐户。By default, this is the SQLServerAgent service account of the secondary server instance, but an administrator can choose another proxy account for the job.

如果备份文件夹位于主服务器上,则键入该文件夹的本地路径If the backup folder is located on the primary server, type the local path to the folder
如果备份文件夹位于主服务器上,则键入备份文件夹的本地驱动器号和路径。Type the local drive letter and path to the backup folder if the backup folder is located on the primary server. 如果备份文件夹不在主服务器上,则可以保留此选项为空白。If the backup folder is not located on the primary server, you can leave this blank.

如果您在此处指定本地路径,则 BACKUP 命令将使用此路径来创建事务日志备份;否则,如果未指定本地路径,则 BACKUP 命令将使用在 “备份文件夹的网络路径” 框中指定的网络路径。If you specify a local path here, the BACKUP command will use this path to create the transaction log backups; otherwise, if no local path is specified, the BACKUP command will use the network path specified in the Network path to the backup folder box.

备注

如果 SQL ServerSQL Server 服务帐户在主服务器上的本地系统帐户下运行,则必须在主服务器上创建备份文件夹,并在此处指定该文件夹的本地路径。If the SQL ServerSQL Server service account is running under the local system account on the primary server, you must create the backup folder on the primary server and specify the local path to that folder here. 主服务器实例的 SQL ServerSQL Server 服务帐户必须对此文件夹具有读写权限。The SQL ServerSQL Server service account of the primary server instance must have Read and Write permissions on this folder.

删除文件,如果其保留时间超过Delete files older than
指定事务日志备份在删除前在备份目录中保留的时间。Specify the length of time you want transaction log backups to remain in your backup directory before being deleted.

在以下时间内没有执行备份时报警Alert if no backup occurs within
指定在引发警报以报告未执行事务日志备份之前,希望日志传送等待的时间。Specify the amount of time you want log shipping to wait before raising an alert that no transaction log backups have occurred.

作业名称Job name
显示 SQL Server 代理作业的名称,该作业用于为日志传送创建事务日志备份。Displays the name of the SQL Server Agent job that is used to create the transaction log backups for log shipping. 首次创建作业时,可以通过在该框中键入内容来修改名称。When first creating the job, you can modify the name by typing in the box.

计划Schedule
显示用来备份主数据库的事务日志的当前计划。Displays the current schedule for backing up the transaction logs of the primary database. 在创建备份作业之前,可以通过单击 “计划...” 来修改此计划。在创建备份作业之后,可以通过单击 “编辑作业...” 来修改此计划。Before the backup job has been created, You can modify this schedule by clicking Schedule.... After the job has been created, you can modify this schedule by clicking Edit Job....

备份作业Backup Job

“计划...”Schedule...
修改在创建 SQL Server 代理作业时创建的计划。Modify the schedule that is created when the SQL Server Agent job is created.

“编辑作业...”Edit Job...
为在主数据库中执行事务日志备份的作业修改 SQL Server 代理作业参数。Modify the SQL Server Agent job parameters for the job that performs transaction log backups on the primary database.

禁用此作业Disable this job
禁止 SQL Server 代理作业创建事务日志备份。Disable the SQL Server Agent job from creating transaction log backups.

压缩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 the following backup compression values for the log backups of this log shipping configuration:

使用默认服务器设置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 the 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.

另请参阅See Also

配置帐户以创建和管理 SQL Server 代理作业 Configure a User to Create and Manage SQL Server Agent Jobs
关于日志传送 (SQL Server)About Log Shipping (SQL Server)