Does distributed sql server require a witness server?

Suy Peang 86 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.
9,070 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. CathyJi-MSFT 20,781 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".