Groups | Blog | Home
all groups > sql server clustering > october 2004 >

sql server clustering : Is it possible to build a cluster with two independent sets of hard drives on each server



Jason Robertson
10/24/2004 2:41:15 AM
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.


Sinisa Perovic
10/25/2004 12:13:03 AM
Yes it is possible using 'Majority Node Set' feature of Windows 2003....but
with some constraints.
see
http://www.microsoft.com/resources/documentation/WindowsServ/2003/standard/proddocs/en-us/Default.asp?url=/resources/documentation/WindowsServ/2003/standard/proddocs/en-us/SAG_MSCS2planning_32.asp

Rgds
Sinisa

[quoted text, click to view]
Mike Epprecht (SQL MVP)
10/25/2004 1:47:05 AM
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

[quoted text, click to view]
Greg D. Moore (Strider)
10/25/2004 1:51:04 AM

[quoted text, click to view]

No.


[quoted text, click to view]

Sinisa Perovic
10/25/2004 7:05:04 AM
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

[quoted text, click to view]
AddThis Social Bookmark Button