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.

But I have 2 SQL 2005 nodes and no shared storage - how we can implement in
this situation SQL Majority Node Set Cluster ?
There is possible? There are other possibilities ?

Thank you in advance,

You can look into SQL Server 2005 database mirroring, although for
automatic failover you will still need a witness server. There are
lesser levels of availability (high protection and high performance
operating modes) you can build with SQL 2005 Database mirroring that
only require 2-Nodes, however the failover is always done manually. It
is more of a DR solution than an HA solution. Check out the details
here...

http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx

http://www.databasejournal.com/features/mssql/article.php/3440511

You can look into third party solutions such as Neverfail and
SteelEye's LifeKeeper (my employer) which provide both the replication
for data protection and application/system level protection using just
two servers. Another benefit of 3rd party clustering is that it will
work fine with Standard versions of Windows and SQL, Enterprise is not
required.

You can request a 30 day free trial from our website at
www.steeleye.com.

David A. Bermingham, MCSE, MCSA:Messaging
Senior Systems Engineer
www.steeleye.com


[quoted text, click to view]