Solved

SQL Server Witness??

Posted on 2011-02-18
1
700 Views
Last Modified: 2012-05-11
I'm setting up my SQL Server into a failover configuration and wonder if I need the SQL Witness.  I want failover to occur automatically.  If I do need SQL Witness, how do I ensure it's redundancy?  It seems like a real chicken and egg problem.
0
Comment
Question by:Phil5780
1 Comment
 
LVL 12

Accepted Solution

by:
mcv22 earned 500 total points
Comment Utility
You will need the witness for automatic failover. If the primary and secondary servers are up and if the witness goes down, it wouldn't initiate an automatic failover (which is the expected behavior) as long as the primary and secondary can communicate. There are ways of ensuring redundancy of the witness - clustering of the witness server(s) is one option.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

762 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now