Hello,

We're are in the basic design process for a cluster. We have some confusion
as to whether SQL Server clustering supports a share nothing scenario - that
is where the clustered machines have their own storage and do not share
storage.

We're trying to find out if this is supported, and if it is, what are the
downsides to this approach versus using a shared storage device.

Any help or comments greatly appreciated.

Thank you,

Greg Hayes

Funny you should use that term. Microsoft uses the shared nothing model,
only it means that the controlling node does not share with any other
node(s). One node owns a resource at a time.

You can get what you need from Majority Node Set (MNS) read all about it
here:

http://www.microsoft.com/windowsserv...lustergeo.mspx

or view an excellent webcast here:
http://support.microsoft.com/default...b;en-us;838612

lastly Tech Net has some great information here:

http://www.microsoft.com/technet/pro...g/majnode.mspx

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering

"Greg Hayes" <grandgousier (AT) verizon (DOT) net> wrote

But as far as I know, SQL 2000 does not support MNS.

--
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Epprecht Consulting (PTY) LTD
Johannesburg, South Africa
Mobile: +27-82-552-0268
IM: mike (AT) epprecht (DOT) net

Specialist SQL Server Solutions and Consulting

MVP Program: http://www.microsoft.com/mvp

"Rodney R. Fournier [MVP]" <rod (AT) die (DOT) spam.die.nw-america.com> wrote in
message news:ewrY7QsaEHA.1732 (AT) TK2MSFTNGP09 (DOT) phx.gbl...

That is true. So third party time it is

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering

"Mike Epprecht (SQL MVP)" <mike (AT) epprecht (DOT) net> wrote