I have to build a SQL server 3 node (ACTIVE-ACTIVE-PASSIVE) cluster (2008) for a client. Both active nodes will be at primary location and one Passive node will be at remote location.
The database size will be in region of 100GB but will grow over time. We are expcting around 1-5% change/addition of data everyday.
I am looking for a good installation guide for clustering.
Do I need domain controller and all nodes part of same domain to get things working? I may have one node located at remote site which may be part of different domain.