Solved

mirroring without witness address

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

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

Title # Comments Views Activity
How to use odbc in vb to connect to ms sql 14 53
SQL Server Question 5 36
migrate a SQL 2008 to 2016, 2 29
Webservices in T-SQL 3 31
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 …
Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

809 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