日志备份 [英] Log backup

问题描述

我对SQL 2016中AG数据库中的转换日志备份有疑问。

I have a question regarding the backup of the transation logs on a DB in AG in SQL 2016.

我已经设置了2个作业，这些作业是从我的两个节点上的维护任务创建的，每晚备份数据库  以及每2小时一次的Tensation日志

I have setup 2 jobs that were create from maintenance tasks on my both Nodes to backup the databse every night  and also Tensation logs every 2 hours

AG设置为Prefer secondary。

The AG is setup for Prefer secondary.

 在辅助节点上运行备份作业时，我可以看到Db获得备份。

 When run the backup job on secondary node I can see that  Db get backup.

我的问题是备份日志

看起来当日志备份作业在主节点上运行时，作业已执行，但没有创建.trn文件。当chekc在辅助节点上作业失败时，我认为这是预期的，因为日志应仅在主节点上获得备份。或者我是
我错了？

It looks like when the logs backup job runs on the Primary Node the job executed but no .trn file is created. when chekc the secondary node the job failed and I think this is expected becuase the logs should get backup only on the Primary node. or am I wrong?

知道为什么没有创建trn文件？

Any idea why no trn file created?

谢谢

Shahin

推荐答案

嗨Shahin，



>>知道为什么没有创建trn文件？



可以你可以尝试勾选下面的截图选项吗？ 

Hi Shahin,

>>Any idea why no trn file created?

Could you please try to tick the option like the screenshot below? 

>>我认为这是预期的，因为日志应仅在主节点上获得备份。或者我错了？



备份日志仅支持常规日志备份（辅助副本上的日志备份不支持COPY_ONLY选项）。请参阅
辅助副本上支持的备份类型。



希望这可以帮助你。


最好的问候，

Cathy Ji

>>I think this is expected because the logs should get backup only on the Primary node. or am I wrong?

BACKUP LOG supports only regular log backups (the COPY_ONLY option is not supported for log backups on secondary replicas). Please refer to Backup Types Supported on Secondary Replicas.

Hope this could help you.

Best regards,
Cathy Ji

这篇关于日志备份的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！