如果作业失败，如何进行日志备份 [英] How to take log backup if job fails

问题描述

您好MSDN， 我有一个日志备份作业，由于意外的网络错误而定期失败（59），并且某些数据库失败并且在下一次计划的运行中失败。在这种情况下没有配置HA。

Hi MSDN,  I have a log backup job which is failing regularly due to unexpected network error(59), and it is failing for some databases and failing on the next scheduled run too. There is no HA configured in this instance.

您能否提出解决上述问题的最佳方法。我应该手动记录日志备份还是只复制日志备份，或者我应该保留它，直到它在下一次计划的运行中成功为止。

Could you suggest the best possible way to resolve the above issue. Shall I take log backups manually or copy only log backups or should I leave as it is until it is successful in its next scheduled runs.

谢谢。

推荐答案

首先尝试解决为什么某些数据库失败的问题。

first try to troubleshoot for why failing for some database.

尝试在本地系统上进行备份

try to take backup on local system

分享错误日志

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