Does distributed sql server require a witness server?

Suy Peang 91 Reputation points
2022-08-31T06:44:49.547+00:00

Hi All,

I have configured Distributed AG multi-site

  • Site A: DB1, DB2
  • Site B: DB3, DB4

On site A, I have installed Window Server Failover Clustering (WSFC) and Add 2 Nodes (DB1, DB2)
On site B, I have installed Window Server Failover Clustering (WSFC) and Add 2 Nodes (DB3, DB4)

For my question, Does each site in (WSFC) require to configure file share witness?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,913 questions
{count} votes

1 answer

Sort by: Most helpful
  1. CathyJi-MSFT 21,096 Reputation points Microsoft Vendor
    2022-08-31T07:29:32.317+00:00

    Hi @Suy Peang ,

    > Does each site in (WSFC) require to configure file share witness?

    Yes, you are right. Even-numbered nodes need to configure quorum. You need to configure a witness for each windows cluster.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    0 comments No comments