使用SQLWriter从AlwaysOn可用性组中的辅助副本备份数据库时出现问题。 [英] Problem using SQLWriter to backup a database from secondary replica in AlwaysOn availability group.

问题描述

使用SQLWriter从辅助副本进行备份时遇到问题。它在主服务器上工作正常，但在我尝试在辅助服务器上执行备份时失败。

I have a problem using SQLWriter to backup from secondary replica. It works just fine on primary, but fails when I attempt to perform backup on secondary.

我有两个节点设置，包括同步提交，自动故障转移和可读辅助设置。尝试从辅助备份时，我收到此错误：

I have two node setup with Synchronous Commit, Automatic Failover and Readable secondary settings. When trying to backup from secondary i get this error:

SqlServerWriter状态为VSS_WS_FAILED_AT_PREPARE_SNAPSHOT

0x800423f4，作家遇到了非瞬态错误。 如果重试备份过程，则可能会再次发生错误。

并且没有进一步的解释为什么会发生这种情况。

And there is no further explanation why this occurred.

如果有人有类似的问题，请回复。

If anyone had a similar problem, please reply.

推荐答案

完整备份似乎只能在辅助副本上进行复制。您的测试是否考虑到了这一点？

It appears that full backups are required to be copy-only on a secondary replica. Does your test take this into consideration?

这篇关于使用SQLWriter从AlwaysOn可用性组中的辅助副本备份数据库时出现问题。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！