Hi,

I have two identical servers. I want to put Win 2003 Enterprise and SQL
Server Enterprise on both of them.
The data will be written to and read from the database.
Is it possible to build a cluster with two independent sets of hard drives
on each server (Server1 with his own hard drives in Raid1, and Server2 with
its own hard drives in Raid1)? As I mentioned the data will be written into
the database continuously. I wanted to check that with you guys because I
have looked into some books about clustering and the only configuration
picures I saw were with a shared array of hard drives between cluster nodes.

Thank you for your help.

"Jason Robertson" <jason6869 (AT) msn (DOT) com> wrote

No.

Yes it is possible using 'Majority Node Set' feature of Windows 2003....but
with some constraints.
see
http://www.microsoft.com/resources/d...lanning_32.asp

Rgds
Sinisa

"Greg D. Moore (Strider)" wrote:

Hi

There was a thread about MNS 13 July 2004 "sqlserver clustering 2 node
cluster without shared storage" in this NG.

SQL Server does not support MNS.

Regards
Mike

"Sinisa Perovic" wrote:

But what if you use , say, log shipping(automatic/manual) for up to date
database or, say, WMI interface or......SQL 2005 Database Mirroring
or.......

rgds
Sinisa

"Mike Epprecht (SQL MVP)" wrote: