Hi.
I am in the process of designing a SQL environement for my companies web app.
It has to be highly available and be within 2 difference Data centre's. Also I require another reporting database for users to run daily/weekly reports.
My initial thought are as follows (all power/infrastructure has been design)
Data centre 1 2 node cluster with share EMC SAN stored.
Data centre 2 1 x server for mirrored database(s) with DC1 1 x snapshot DB (of mirror) for reporting service.
Each DC will be in a 3 node VM cluster.
Do you guys have any other thought.. Also, as this is serving a web app I will advising the dev's to use the "failover" with the connection string, can this cause issues if node1 in the cluster fails over to node2??? Was just thing that the witness servers may thing that the server/db is unavailable therefore make the mirror in DC2 active!
Cheers
JL