Solved

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

Posted on 2016-11-10
6
49 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 25

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 47

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
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 
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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Resolve DNS query failed errors for Exchange
I have a large data set and a SSIS package. How can I load this file in multi threading?
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

803 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