SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 High Availability (2008)
 failover clustering
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

aradhyakiranbm
Starting Member

India
3 Posts

Posted - 07/19/2010 :  02:15:45  Show Profile  Reply with Quote
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 clustering

thanks
kiran aradhya
Bangalore.



Kiran Aradhya
Application engineer

Kiran Aradhya
Application engineer

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 07/19/2010 :  03:57:46  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
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 Shaw
SQL Server MVP
Go to Top of Page

aradhyakiranbm
Starting Member

India
3 Posts

Posted - 07/19/2010 :  09:58:00  Show Profile  Reply with Quote
Hello Gail Shaw ,

Thank you for this clarification ,

My client needs :

Installation and Configuration of Operating systems
Installation of SQL Server
Configuration of Load Balancing
Installation and Configuration Application Clusters
Configuration / Replication of SQL Cluster

Testing Load Balancing , Testing SQL Cluster/Database Sync ,testing application Clustering

can you please suggest me how to go about it ,
or can please provide me any supporting document and links
or feel free to mail me at kiran.aradhya@technextsystems.com

warm regards
kiran



Kiran Aradhya
Application engineer
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 07/19/2010 :  10:58:53  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
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 Shaw
SQL Server MVP
Go to Top of Page

jen
Flowing Fount of Yak Knowledge

Sweden
4110 Posts

Posted - 08/17/2010 :  07:46:56  Show Profile  Send jen a Yahoo! Message  Reply with Quote
they don't want shared storage because they cannot afford a SAN and still want clustering? google iSCSI

otherwise I think they want replication, logshipping or mirroring

--------------------
keeping it simple...
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000