Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

How do you determine what the Witness server is on SQL Server 2012 HA Cluster

Posted on 2016-11-10
6
54 Views
Last Modified: 2016-11-14
Heyas,

As the above title, How do you determine what the Witness server is on SQL Server 2012 HA Cluster?

SQL Server seems to show nothing, anywhere in Windows Server 2012 I can check?

Thank you.
0
Comment
Question by:Zack
6 Comments
 
LVL 26

Expert Comment

by:Dr. Klahn
ID: 41883351
These two sites discuss the issue, which apparently is not as simple as it should be.

https://msdn.microsoft.com/en-us/library/ms178655.aspx

http://www.sqlservercentral.com/Forums/Topic548461-146-1.aspx
0
 
LVL 48

Accepted Solution

by:
Vitor Montalvão earned 250 total points
ID: 41883420
A Cluster doesn't have a witness.
The witness server is used for Mirroring solutions.
0
 
LVL 12

Expert Comment

by:Máté Farkas
ID: 41883904
Maybe this one:
select * from sys.database_mirroring_withnesses

Open in new window

0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 42

Assisted Solution

by:EugeneZ
EugeneZ earned 250 total points
ID: 41885325
if you meant  clustered Witness File Share location   -- quorum

you can check this from the Cluster Manager Console
Or Using PS script:
Get-ClusterQuorum
Get information about the quorum configuration of a failover cluster.
0
 

Author Comment

by:Zack
ID: 41885941
Heyas,

My apologies it's a database mirroring witness server. I have found its name of the Witness Server via our network admin where is this configured inside SQL server?

Thank you.
0
 

Author Closing Comment

by:Zack
ID: 41885952
Found it myself in Database -> Properties -> Mirroring thank you for the assistance.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
This tutorial will walk an individual through the process of installing of Data Protection Manager on a server running Windows Server 2012 R2, including the prerequisites. Microsoft .Net 3.5 is required. To install this feature, go to Server Manager…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question