Solved

mirroring without witness address

Posted on 2011-03-09
3
444 Views
Last Modified: 2012-05-11
Hello!
   i have 2 DB where the witness address is missing it is our virtual machines, and it is V.V.important
that the mirror is not broken.

1. how to i implement the witness adress
2. If i do it will the mirror be broken?

 Shanj
0
Comment
Question by:shanj
  • 2
3 Comments
 
LVL 9

Accepted Solution

by:
kaminda earned 250 total points
ID: 35093444
Not having your witness server present will not break your Mirroring functionality. But automatic failover wont work. So if you dont like to be your database offline in a event of a primary database failure, it is better to setup another witness server sooner. This would be helpful for you ..

http://msdn.microsoft.com/en-us/library/ms365603.aspx
0
 

Assisted Solution

by:shanj
shanj earned 0 total points
ID: 35093716
Hello Kamida!
                 i have a mirror today without witness.

question.

how do i connect it to a witness server? we have also a witnss server .

shaj
0
 

Author Closing Comment

by:shanj
ID: 35170973
NICE
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

932 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

11 Experts available now in Live!

Get 1:1 Help Now