troubleshooting Question

Sql Clustering with mirroring options

Avatar of Network_Padawan
Network_Padawan asked on
StorageMicrosoft SQL Server 2008Disaster Recovery
16 Comments1 Solution770 ViewsLast Modified:
Hi all,

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?
Join our community to see this answer!
Unlock 1 Answer and 16 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 16 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros