Reply to: Question for the Experts: HA MS-CS and SQL Server

[milanbenes]

he he very good

Milan.

[mcquiggd]

Which machine did you leave the back up tape in...?

P.S Doomed!

[milanbenes]

Dave,

many thanks.

Darmstadt thank you too.

Oh well more Sunday working then.

Contracting, every little helps.

Milan.

[DaveB]

Having been on the reciving end of the same situation I can tell you you are probably screwed. Do it the safe way and shutdiown cleanly then restart when the network \comes back.

[darmstadt]

Seeing as you're in Frankfurt you can just give me a bell and I'll come up and sort it out for you. The number is 110.

[milanbenes]

I'm not expecting you noddy's to understand hadr or cadr

Milan.

[darmstadt]

MS, CS, HA...what the hell does that all mean? They're not even proper TLAs. If its Microsoft then just reboot everything, that tends to work.

[ratewhore]

thats just not the attitude, it really isn't...

[RW in NL drone mode]

[milanbenes]

Ratewhore,

you'd probably have a situation like the UK in general where everyone is taken up the backside and doesn't do anything about it for fear of going again the PC grain.

Go on, be a devil, break a rule.

Milan.

[DimPrawn]

.NET is the future

[ratewhore]

Still should be in the technical forum. Where would we be if everyone flouted the rules like you Milan?

[milanbenes]

thanks Vic.

both nodes will lose their network.

Looks like MS-CS will be fecked.

Oh well one good thing about MS, it should work after a restart.

Ok we can plan for this.

Milan.

[AtW]

[Viktor]

Have a look at this:

http://www.microsoft.com/technet/pro...g01.mspx#EIGAG

It's always better to have a cross-over for the heartbeat network, or a dedicated switch. The nodes see each other through the heartbeat network, the master remains the one who owns the shared disks (active/passive config).
If the passive node goes away in cluster admin, evict the node and add again the server. Normally the nodes should pick-up from the quorum log, but you never know...

Hope every little advice helps,

Viktor

[milanbenes]

AtW,

I am talking about the Microsoft Cluster Service software not crashing when the network goes down.

Secondly, a clustered database is a clustered database singular, one database clustered between two servers with a quorum disk giving an attempt at a singular highly available DB if one server goes down running the db then the db is moved to the other server by MS-CS - in principle - however MS-CS does not always do what says on the box hence my question.

To conclude, AtW, if you are not sure what I am talking and therefore don't know the answer please continue writing your SKA and avoid filling this useful thread with crap.

Thanks,

Milan.