在 SQL Server 可用性组的上下文中,监视文件共享见证的可访问性的最佳方法是什么?
我想确保可用性组副本可以访问见证,这与仅可用不同。例如,用于运行 SQL Server 的帐户需要对文件共享的访问权限。
编辑:我最近注意到集群记录的一些值得监控的事件。
Log Name: System
Source: Microsoft-Windows-FailoverClustering
Date: 6/1/2019 1:23:09 PM
Event ID: 1564
Task Category: File Share Witness Resource
Level: Critical
Keywords:
User: SYSTEM
Computer: node1.contoso.com
Description:
File share witness resource 'File Share Witness' failed to arbitrate for
the file share '\\servername\sharename'. Please ensure that file share
'\\servername\sharename' exists and is accessible by the cluster.
Log Name: System
Source: Microsoft-Windows-FailoverClustering
Date: 6/1/2019 1:23:08 PM
Event ID: 1562
Task Category: File Share Witness Resource
Level: Warning
Keywords:
User: SYSTEM
Computer: node1.contoso.com
Description:
File share witness resource 'File Share Witness' failed a periodic health
check on file share '\\servername\sharename'. Please ensure that file
share '\\servername\sharename' exists and is accessible by the cluster.