Hi all, if you have an option to create the best solid DataCenter failover solution using the latest technology's including in SQL 2011 what would that be?
The main point here is to reduce the business downtime while the databases and web servers are involved with OS patching,
hardware maintenance, database maintenance, etc.
Fast application failover between Data Centers during planned and unplanned downtime is very important.
Will Multi-Subnet Failover Clustering work in this case along with replication? ( what kind of replication? )
How about the AlwaysOn feature?
I know it's a little early for Denali but still...