Sharepoint 2010 SQL 2008 R2 Mirroring over WAN link
Posted on 2011-03-23
Has anyone experience of Sharepoint 2010 SQL 2008 R2 database mirroring over a WAN link ? I know the supported scenarios, our WAN link will be average anything from about 2ms-20ms round trip, and there will be a limited number of low-usage, smallish (less than 20GB) databases and ideally, would like to do High-Availability with automatic failover, but probably more realistically, to avoid spurious failovers due to loss of connection to witness, High Availability with manual failover. It is essentially for business continuance in the event that a WAN link goes down, or that we lose the SQL server in the primary site. We would also like to be able to use full failover and run completely from the other site (will install another WFE server in DR site for this).
So really looking for experiences, advice etc.