Mirroring with witness end point on mirror server

Question

Mirroring with witness end point on mirror server

shah.smit

Grasshopper

Points: 14
More actions
July 31, 2012 at 7:42 am

#265053

hi,
i have only 2 servers and also want to configure witness
with that i want to configure witness end point on mirrored server
is it possible? if yes then how?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

winston Smith SSCoach Points: 19498 More actions · Answer 1

"The witness server instance can run on the same computer as the principal or mirror server instance, but this substantially reduces the robustness of automatic failover. "

http://msdn.microsoft.com/en-us/library/ms190430(v=sql.105).aspx

shah.smit Grasshopper Points: 14 More actions · Answer 2

Hi Winston,

thnks for the rpy....

this link is very helpful.

one more thing i want to know that... after failover mirror(srvr2) will be principal and principal(srvr1) will be mirror so at that time witness(srvr2) will be on principal... so my que is at that time can we configure witness on srvr1 which was previously(before failover) on srvr2???

winston Smith SSCoach Points: 19498 More actions · Answer 3

shah.smit (8/1/2012)
one more thing i want to know that... after failover mirror(srvr2) will be principal and principal(srvr1) will be mirror so at that time witness(srvr2) will be on principal... so my que is at that time can we configure witness on srvr1 which was previously(before failover) on srvr2???

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

The above link details how to add or replace a witness via SSMS. I guess this could be scripted, but I have never tried and would have to do some research.

There is no built in way that I am aware of to automatically move the witness so that after failover it is on the new mirror server.

shah.smit Grasshopper Points: 14 More actions · Answer 4

Hey winston,

this is the doc i was looking for...

thanks a lot for the help....