Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Majority Node Set SQL cluster Or ?

 
   Database Forums (Home) -> Clustering RSS
Next:  Issue with path / permissions for linked table  
Author Message
Mr.B

External


Since: Jul 02, 2007
Posts: 3



(Msg. 1) Posted: Thu Dec 13, 2007 4:44 am
Post subject: Majority Node Set SQL cluster Or ?
Archived from groups: microsoft>public>sqlserver>clustering (more info?)

S it possible to set up SQL cluster like MNS, without having common share
drives ? or without vendor specific solution.

Target is to have high-availability, but have no SAN or share SCSI drives
available.

I can set up mirroring, at the moment these is the only solution that I
thing is possible. Both servers are in same location.

 >> Stay informed about: Majority Node Set SQL cluster Or ? 
Back to top
Login to vote
Edwin vMierlo [MVP]

External


Since: Apr 04, 2007
Posts: 18



(Msg. 2) Posted: Thu Dec 13, 2007 9:58 am
Post subject: Re: Majority Node Set SQL cluster Or ? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

MNS only removes the need for a shared Quorum Disk, you still need disks for
your SQL data to be shared disks



"Mr.B" wrote in message

> S it possible to set up SQL cluster like MNS, without having common share
> drives ? or without vendor specific solution.
>
> Target is to have high-availability, but have no SAN or share SCSI drives
> available.
>
> I can set up mirroring, at the moment these is the only solution that I
> thing is possible. Both servers are in same location.
>

 >> Stay informed about: Majority Node Set SQL cluster Or ? 
Back to top
Login to vote
Mr.B

External


Since: Jul 02, 2007
Posts: 3



(Msg. 3) Posted: Thu Dec 13, 2007 9:58 am
Post subject: Re: Majority Node Set SQL cluster Or ? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Thank you. I will set up miroring.

"Edwin vMierlo [MVP]" wrote:

> MNS only removes the need for a shared Quorum Disk, you still need disks for
> your SQL data to be shared disks
>
>
>
> "Mr.B" wrote in message
>
> > S it possible to set up SQL cluster like MNS, without having common share
> > drives ? or without vendor specific solution.
> >
> > Target is to have high-availability, but have no SAN or share SCSI drives
> > available.
> >
> > I can set up mirroring, at the moment these is the only solution that I
> > thing is possible. Both servers are in same location.
> >
>
>
>
 >> Stay informed about: Majority Node Set SQL cluster Or ? 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Majority Node Set cluster - If you want to deploy a SQL 2005 geocluster or a cluster without shared storage for quorum - there is only Windows 2003 Ent Edition "Majority Node Set" option. Majority Node Set implies three nodes for failover - in case one node is failing....

4 node cluster - Has anyone set up a 4 node cluster i.e. 3 active and 1 passive ? I only want to consider this as it may reduce cost. We have a lot of servers and the least i want to do is have an active passive 2 node cluster for every server thus doubling the server...

2 node SQL 2005 cluster - I am new to clustering. I will be setting up a 2 node cluster using W2k3 EE and SQL 2005. I have a Dell PE 2850 and Dell PE 1850 for the servers, each containing one 73 GB HD and a PowerVault 220 with 4-73GB HD’s for the shared Drive. I am uncertain...

One node Cluster for SQL 2005 - Hi anyone know if you can cluster sql on a one node cluster in Windows 2003 ? Regards Craig

4 node cluster - I want to set up a 4 node cluster where 3 nodes are active and 1 is the passive node that would take over in case any one of those 3 active nodes fail. How can I set this up ? Any documentation.. Using SQL 2005..
   Database Forums (Home) -> Clustering All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]