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

mirroring without witness address

Posted on 2011-03-09
3
446 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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

856 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