I posted a few days ago a question pertaining to a solution I am trying to design for our sql database servers, and I have a question regarding the answers I got which I just thought of.
I wanted to setup a redundant SQL cluster in site1 and somehow replicate the data to Site2 for DR purposes. I was advised the best solution is to have a SAN and form a cluster for local redundancy in site1 and do an asynchronous replication to siteb. What I dont understand is asynchronous replication is obviously mirroring....but how do I set that up using the cluster if its design to failover to a passive node if the active fails? Mirroring uses async replication with a witness for failover...but I don't understand how this would work if during a failover I obviously want the passive node in the cluster to take over the requests instead of a mirror-induced failover to the DR site...
Is there a way to setup async replication without mirroring?