Witness Server DB Mirroring

Question

Witness Server DB Mirroring

anarayanamoorthy

SSC Veteran

Points: 293
More actions
June 11, 2012 at 5:17 am

#262256

I have set up a database mirroring in a production server. When the principal server failover its not getting automatically mirrored to the mirror server. I have checked one of my user database in the properties tab and have given the TCP port perfectly. I have to do a manual failover all the time.

Viewing 15 posts - 1 through 15 (of 19 total)

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Is there a witness server?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

anarayanamoorthy SSC Veteran Points: 293 More actions · Answer 2

Yes I have a witness server, Mirror server and principal server.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

Right click on the principal database, click on properties. Select the Mirroring page and look at the Operating Mode. What is selected there?

MANU-J. SSC-Dedicated Points: 31126 More actions · Answer 4

Do you get any row in output if you execute select * from master.sys.database_mirroring_witnesses?

MJ

anarayanamoorthy SSC Veteran Points: 293 More actions · Answer 5

Lynn,

Its high safety with automatic failover(Synchronous) but its graded out.

anarayanamoorthy SSC Veteran Points: 293 More actions · Answer 6

Manu,

I did not get any output post execution of the query in Principal server.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 7

anarayanamoorthy (6/12/2012)
Lynn,
Its high safety with automatic failover(Synchronous) but its graded out.

Can you post a screen shot of the page?

anarayanamoorthy SSC Veteran Points: 293 More actions · Answer 8

anarayanamoorthy

SSC Veteran

Points: 293

June 13, 2012 at 5:07 am

#1500259

Enclosed is the attachment of the snapshot Lynn.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 9

anarayanamoorthy (6/12/2012)
Manu,
I did not get any output post execution of the query in Principal server.

You should only get a result set when run on a server operating as a witness to database mirroring. If your principal and mirror servers are not also working as a witness to other mirror setups this system dmv should be empty on these servers.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 10

What does the following return on both principal and mirror servers: select * from sys.database_mirroring.

anarayanamoorthy SSC Veteran Points: 293 More actions · Answer 11

Lynn,

Find the attached image which consists of output from the witness server.

saidapurs Hall of Fame Points: 3477 More actions · Answer 12

Hi Gross,

Did u resolve this issue or not yet?

Did you check all server SP & SQL SP are same...

anarayanamoorthy SSC Veteran Points: 293 More actions · Answer 13

anarayanamoorthy

SSC Veteran

Points: 293

June 26, 2012 at 10:53 am

#1505719

Please find the output from witness server.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 14

anarayanamoorthy (6/26/2012)
Please find the output from witness server.

First, it doesn't show all the fields (columns). Second, doesn't really provide much information other than the witness is involved in several mirrored setups.

What about the the query I sent you to run on the mirror and principal servers? Also, since it looks like you have several databases mirrored, is this isolated to only one mirrored database or are the others experiencing the same problem?