Looking to implement a new MS SQL Database setup in our data center and need some guidance on how to properly implement High Availability in MS SQL. We are currently looking at using 2008 R2 but want our solution to be upgradable to 2012 when it is released.
Anyway, our requirements are fairly simple. We need to be able to setup 2 separate database servers that each have their own copy of the data so that they can run both together for load balancing and individually for high availability. Our total data storage will probably be in the area of 4TB and the majority of the storage and transactions will be related to a SharePoint Server Farm.
It is important that we can have both load balancing and high availability in our setup.
What are our options to do this in the simplest way possible?