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 |
|
aradhyakiranbm
Starting Member
3 Posts |
 Posted - 2010-07-19 : 02:15:45
|
| Dear members ,I 'm trying to configure a fail over clustering for a client ,whose requirement states that :Clustering should replicate data for two nodes without storage or a quorum .what i have experimented:I was trying to configure windows server 2003 enterprise edition and then tried to configure sql server over it . i have made one as active directory and domain controller , added the other as its member .i was not possible to proceed without an external storage drive even after selecting majority set property (i.e., local storage disk)my doubt :[/b]is it possible without clustering the server 2003 with only sql server 2005 ?how can i replicated data with in two nodes in case of failover ?I need a help or any supporting document to resolve this clusteringthankskiran aradhyaBangalore.Kiran AradhyaApplication engineerKiran AradhyaApplication engineer |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-07-19 : 03:57:46
|
| What you're describing there is not failover clustering. Failover clustering requires shared storage and a quorum drive. Might be worth getting some more details from the client, what they really want, what the point of this is (scale-out or HA), what their requirements are.--Gail ShawSQL Server MVP |
 |
|
|
aradhyakiranbm
Starting Member
3 Posts |
Posted - 2010-07-19 : 09:58:00
|
| Hello Gail Shaw ,Thank you for this clarification ,My client needs :Installation and Configuration of Operating systemsInstallation of SQL Server Configuration of Load BalancingInstallation and Configuration Application ClustersConfiguration / Replication of SQL Cluster Testing Load Balancing , Testing SQL Cluster/Database Sync ,testing application Clusteringcan you please suggest me how to go about it , or can please provide me any supporting document and linksor feel free to mail me at kiran.aradhya@technextsystems.comwarm regardskiranKiran AradhyaApplication engineer |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-07-19 : 10:58:53
|
| SQL doesn't have any built-in load balancing.There's not enough info there to help. Most of those should be easy enough to do. You need to sit down and get detailed requirements for the replication/load balancing to see what they want and how you might be able to implement it.--Gail ShawSQL Server MVP |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2010-08-17 : 07:46:56
|
| they don't want shared storage because they cannot afford a SAN and still want clustering? google iSCSIotherwise I think they want replication, logshipping or mirroring--------------------keeping it simple... |
|
|
|
|
|
|
|
|
failover clustering