?
Solved

mirroring without witness address

Posted on 2011-03-09
3
Medium Priority
?
452 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
[X]
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
  • 2
3 Comments
 
LVL 9

Accepted Solution

by:
kaminda earned 1000 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

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

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

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

801 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