up vote 0 down vote favorite
1
share [g+] share [fb]

We currently have the one server doing MSSQL/IIS. Can use NLB with two servers running IIS for HA and can use database mirroring and put the failover partner in the connection string for HA.

Can we use NLB + Mirroring together? So if one of the servers died (ie power plug removed), everything will continue to work (after the timeout for the mirror to become the principal)?

link|improve this question
will this work: bump? – Igor K May 25 '10 at 10:40
feedback

2 Answers

up vote 0 down vote accepted

Simple answer is yes it should work once you get NLB & the SQL mirror configured correctly.

link|improve this answer
Thanks, thats good enough for me :) – Igor K May 25 '10 at 10:50
feedback
up vote 0 down vote

Is there anywhere a description of exactly how to do that?

Regards

link|improve this answer
I've set up the machines successfully and it all works wonders. I can set up NLB to direct all traffic to Server1 and failover to Server2 if unavailable. The mirroring works very well. Ie can set up Server2 as the principal and with a third witness server, it will automatically failover to Server1 if it goes offline. I've tested removing the power from each server and it "just works". So it can be done, but with 3 servers, you need 1 for a witness. You could get a really cheap $15 a month Windows VM for the witness with gigenetcloud.com – Igor K Jun 11 '10 at 13:13
feedback

Your Answer

 
or
required, but never shown
discard