On our SharePoint 2010 farm, we are using SQL 2008 R2. Currently, a SQL cluster (with 2 SQL server sitting at same data center) is built to provide auto-failover. However, it has no DR ability.
We are requested to provide DR ability to the system. One of approach we are considering is adding a new SQL server (the 3rd server) at DR site. Then setup mirroring with the SQL cluster. Is it possible for SQL 2008 R2?
I think not many systems is setup in this way. I fail to find any supporting document from Microsoft or from the Internet.