Do we need to set the preferred node?

Question

Do we need to set the preferred node?

passivebyz

SSCommitted

Points: 1908
More actions
August 30, 2010 at 12:59 pm

#223276

Hi,
We have 2 node A/P set up for SQL Server 2008 on Windows Server 2008. Everything is running fine. But in Preferred owners list, there is NO node is selected.
Do we MUST need to set the preferred Owner?
Thanks

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

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

No - it is not required.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Perry Whittle SSC Guru Points: 234013 More actions · Answer 2

I always set it, but only really required if you intend to configure\use failback policies!

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

Derrick Smith SSChampion Points: 10833 More actions · Answer 3

I never worry about a preferred node..Never really understood that anyway, since both nodes should be identical hardware/settings. It shouldn't matter which one it's on.