Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mahes
Starting Member
4 Posts |
 Posted - 2010-06-15 : 00:03:12
|
| Hi,I would like to design DR solution between 2 building have same subnet mask for 2 sq servers 2008 on Win 2008 but I’m having issue of shared storage. I thought to have clustered sql on local drive and use mirror to synchronize data between databases. Later I knew that I cannot have mirroring with cluster for reasons1- Cluster uses virtual name whereas when failover it cannot use mirrored Database2- Mirror Database failover before cluster Could anyone suggest how I can implement such scenario? I know mirror will be enough if we have witness server but the business is looking for clustered serverThanks in advance |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2010-06-22 : 00:46:24
|
| There is a geographic limitation for clustering. i believe it is 8 Km (i read at somewhere. Tara, kindly correctme if i'm wrong).Clustering is hardware level failover, and mirroring is software failover. please update the same to you business, and force them to have Mirroring.ArnavEven you learn 1%, Learn it with 100% confidence. |
 |
|
|
mahes
Starting Member
4 Posts |
Posted - 2010-07-03 : 23:41:17
|
| Hi,Cluster is must. I need to find how to implement it. Does any one have steps to do on SQL2008. the distance between 2 buiding is 1 Km. Thanks |
|
|
|
|
|
|
HA geo clustrer and mirror for sql server