I read that its possible to implement an Active/Active/Active with SQL 2000
on Win Server 2003 Ent without SAN but could not find a good step by step
howtos to it.

Could some kind gentlemen point me to a good article ? please and thanks in
advance.

SCSI clusters only support two nodes. As far as Active/Active/Active
terminology, that really doesn't express what your intent is. The new
terminology is Multi-instance and you need to state how many nodes and SQL
instances you are trying to build in your cluster. I.E I want to build a
four node cluster with three SQL instances.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP


"Lewis" <Lewis (AT) discussions (DOT) microsoft.com> wrote

My setup is a 2 data center, 2 server in location and 1 single in another. I
would like to implement a fail safe SQL system. So this will be a 3 node
system and I am intending that at any single update to database, all 3 will
be updated instantly. Because its not in the same datacenter, therefore
implementing a SAN is not possible, so with this in mind can my original
question be possible and is there any Howtos document to follow.. appreciate
any assistance.

"Geoff N. Hiten" wrote:

What you are asking about is a Geo-cluster or a geographically separated
cluster. NSI makes some products that can give you this functionality. Some
SAN vendors also handle SAN-level data replication for disaster
recovery/fault tolerance setups. There are no built-in features in SQL
Server 2000 to allow what you are asking for. SQL Server 2005 adds a new
technology called Database Mirroring that allows you to build a multi-site
high-availability solution.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

"Lewis" <Lewis (AT) discussions (DOT) microsoft.com> wrote

Sorry Geoff.N, if its not troublesome, may I communicate with u via email or
MSN, I really appreciate if its possible to understand better on this subject.

"Geoff N. Hiten" wrote:

My MSN is lewisteo (AT) hotmail (DOT) com

"Geoff N. Hiten" wrote:

I prefer to assist on the public newsgroups where everyone can benefit from
the discussions. Private assistance is known as "consulting" and is
generally done for pay.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

"Lewis" <Lewis (AT) discussions (DOT) microsoft.com> wrote

Not a problem, as I was saying, my setup is such:

Data Center 1:
2 x server with Win 2K3 Server EE / MS SQL 2000 E, lease line to the
internet, another lease line to data center 2.

Data Center 2:
1 x server with Win 2K3 Server EE / MS SQL 2000 E, lease line to the
internet and another leased to data center 1.

I would like to have all servers in both data center clustered for
redundancy, is this possible ?

"Geoff N. Hiten" wrote:

At this time, you cannot cluster using native SQL tools across a geographic
separation. Also, I think you may have an incomplete understanding of how
clustering works and what it actually offers. The following article is a
good starting point. It mostly describes running in a Windows 2000
environment. There are a few technical differences when running on Windows
2003, but the fundamentals are the same.

Microsoft Whitepaper - SQL Server 2000 Failover Clustering
http://www.microsoft.com/technet/pro.../failclus.mspx

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

"Lewis" <Lewis (AT) discussions (DOT) microsoft.com> wrote