I am curious as to how would one go about setting up full fault tolerant SQL 2005 Enterprise and Win 2003 Enterprise cluster with automatic fail-over.
I know I need multiple database servers, 2 fiber switches, 2 SANs and 2 HBA for each of the servers.
Each of the designs I've seen showed the use of one SAN where I guess they assumed that the SAN would not go down, but I would like to have second SAN in case the first one fails for whatever reason...
Can someone please provide as detailed configuration of such setup as possible?
I have multiple IBM 335 servers and I am thinking of getting two Dell PowerVault 660F SANs with 2 Dell 56F fiber switches (EBAY) unless someone can suggest better hardware configuration (cost effective).