Majority Node Set SQL cluster Or ?

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.
MNS only removes the need for a shared Quorum Disk, you still need disks for
your SQL data to be shared disks
"Mr.B" <MrB@.discussions.microsoft.com> wrote in message
news:39BE540E-15FA-4CB9-811D-2B1279B0CA61@.microsoft.com...
> 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.
>
|||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" <MrB@.discussions.microsoft.com> wrote in message
> news:39BE540E-15FA-4CB9-811D-2B1279B0CA61@.microsoft.com...
>
>

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.
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/pro.../dbmirror.mspx
http://www.databasejournal.com/featu...le.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
anonymous wrote:
> 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,
|||"anonymous" <anonymous@.discussions.microsoft.com> wrote in message
news:88AA523B-7A76-4E5C-B507-468EF6DF7B02@.microsoft.com...
> 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 ?
MNS covers _only_ the quorum. If you want to cluster SQL 2005, you will need
shared storage for the database and transaction logs.
You can use 3rd party software for this, but if you do, then you must depend
on them for your support, too.
Another option you have with SQL 2005 is to use Database Mirroring. See
books online for additional information.
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp

Majority Node Set and SQL Server 2000

Hello
I was doing some research about Windows 2003 Cluster with Majority Node Set
and SQL Server 2000 EE support.
I found some messages on the newsgroup saying that SQL Server 2000 is not
supported on MNS cluster.
I also read on SQL Server 2000 High Availability book on page 158 that SQL
Server support both cluster types (MNS and Shared Storage).
I also did not find any official documentation on the Microsoft web site
staying that SQL Server 2000 clustering is not supported on a MSCS configured
with MNS.
Because of that I am a lit bit confused.
Anyone know any document com Microsoft where its possible to read that SQL
Server 2000 is not supported on an MNS cluster?
I belive that is not possible to install SQL Server 2000 virtual server on a
MNS quorum because the SQL Server needs a shared storage for the system and
user databases. But It would be possible to install the WIndows 20003 cluster
on a MNS and them install SQL Server 2000 virtual server on a shared storage
(SAN)?
Regards
Carlos Eduardo Selonke de Souza
http://carlos.geekbunker.org
Hi
Have a look at the last post on this
http://groups.google.com.au/group/mi...f897c8231ea9f2
http://groups.google.com.au/group/mi...c936d07ef15cda
http://groups.google.com.au/group/mi...a0220e71bc8008
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Carlos Eduardo Selonke de Souza"
<CarlosEduardoSelonkedeSouza@.discussions.microsoft .com> wrote in message
news:529DAF39-A3E6-4451-AE79-B91695CDFE7F@.microsoft.com...
> Hello
> I was doing some research about Windows 2003 Cluster with Majority Node
> Set
> and SQL Server 2000 EE support.
> I found some messages on the newsgroup saying that SQL Server 2000 is not
> supported on MNS cluster.
> I also read on SQL Server 2000 High Availability book on page 158 that SQL
> Server support both cluster types (MNS and Shared Storage).
> I also did not find any official documentation on the Microsoft web site
> staying that SQL Server 2000 clustering is not supported on a MSCS
> configured
> with MNS.
> Because of that I am a lit bit confused.
> Anyone know any document com Microsoft where its possible to read that SQL
> Server 2000 is not supported on an MNS cluster?
> I belive that is not possible to install SQL Server 2000 virtual server on
> a
> MNS quorum because the SQL Server needs a shared storage for the system
> and
> user databases. But It would be possible to install the WIndows 20003
> cluster
> on a MNS and them install SQL Server 2000 virtual server on a shared
> storage
> (SAN)?
> Regards
> --
> Carlos Eduardo Selonke de Souza
> http://carlos.geekbunker.org

Majority Node Set ?

Hello All
Has anyone created a clustered sql2000 instance on windows 2003 in different
geographical areas? I gather this can be done, but there is no shared
storage as such. I believe one has to replicate data another way.
I am looking for some docs on this before I dive in!
Thanks
Simone
Save yourself the trouble. SQL depends on shared storage for the data as
well as the cluster state. No Majority Node Set for SQL Server.
Geoff N, Hiten
Microsoft SQL Server MVP.
"Simone Harris" <pleasenospam@.here.com> wrote in message
news:%23eWcFPTYFHA.3712@.TK2MSFTNGP09.phx.gbl...
> Hello All
> Has anyone created a clustered sql2000 instance on windows 2003 in
> different geographical areas? I gather this can be done, but there is no
> shared storage as such. I believe one has to replicate data another way.
> I am looking for some docs on this before I dive in!
> Thanks
> Simone
>
|||Many thanks
"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:efOOlvVYFHA.2664@.TK2MSFTNGP15.phx.gbl...
> Save yourself the trouble. SQL depends on shared storage for the data as
> well as the cluster state. No Majority Node Set for SQL Server.
> Geoff N, Hiten
> Microsoft SQL Server MVP.
> "Simone Harris" <pleasenospam@.here.com> wrote in message
> news:%23eWcFPTYFHA.3712@.TK2MSFTNGP09.phx.gbl...
>