SQL Server Mirroring has an asych mode too: http://technet.microsoft.com/en-us/library/cc917680.aspx
Also, SQL Server Mirror can be brought online automatically. SAN sync to a geo stretched cluster will probably be very expensive. Usually SAN sync is to an offline DB, with the cluster at the other end separate to the cluster at the source. Not sure if a geo-stretched cluster can utilise SAN sync (though happy to be educated) Cheers Ken -----Original Message----- From: Mike Leone [mailto:[email protected]] Sent: Monday, 11 April 2011 11:05 PM To: NT System Admin Issues Subject: Re: Q about multi-site SQL cluster On 4/11/2011 9:22 AM, Ken Schaefer wrote: > Also +1 to Brian's comments. Do you really need a stretched cluster? > Mirroring can provide auto-failover at the SQL Server level. He tells me we will have asynchronous mirroring between the sites. (it's SAN replication, between HP SANs .. or will be, when we get to setting it up). Not sure how that affects the discussions, tho. He says he will dig more into it. Thanks for the help so far. No doubt he'll be back with more questions soon. :-) ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin
