dbTalk Databases Forums  

SQL active-active setup on windows clustering

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss SQL active-active setup on windows clustering in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
DD
 
Posts: n/a

Default SQL active-active setup on windows clustering - 01-28-2010 , 03:23 AM






we would like to setup the SQL DB using windows cluster, is it a must to have
external storage ?

the 2 server have Raid 5 configure, can we implement without external
storage ?

Reply With Quote
  #2  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: SQL active-active setup on windows clustering - 01-28-2010 , 12:19 PM






You need storage connected to all nodes so the SQL instance can fail over
correctly. If you do not have external storage, I suggest mirroring as your
core availability technology.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP


"DD" <DD (AT) discussions (DOT) microsoft.com> wrote

Quote:
we would like to setup the SQL DB using windows cluster, is it a must to
have
external storage ?

the 2 server have Raid 5 configure, can we implement without external
storage ?

Reply With Quote
  #3  
Old   
daveberm
 
Posts: n/a

Default Re: SQL active-active setup on windows clustering - 01-30-2010 , 10:13 PM



On Jan 28, 4:23*am, DD <D... (AT) discussions (DOT) microsoft.com> wrote:
Quote:
we would like to setup the SQL DB using windows cluster, is it a must to have
external storage ?

the 2 server have Raid 5 configure, can we implement without external
storage ?
Yes, you can do it by implementing a multi-site cluster.

http://download.microsoft.com/downlo...Clustering.doc

This requires the use of a 3rd party replication solution that
integrates with failover clustering. In your case, you will need a
3rd party host based replication solution such as SteelEye DataKeeper
Cluster Edition. Here is a STep-by-Step article that shows you how to
do it.

http://clusteringformeremortals.com/...%80%93-part-3/

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.