Active/Active/Active without SAN

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@.discussions.microsoft.com> wrote in message
news:3C882765-40EE-424E-8BEF-A5F768D2207D@.microsoft.com...
>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.
|||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:

> 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@.discussions.microsoft.com> wrote in message
> news:3C882765-40EE-424E-8BEF-A5F768D2207D@.microsoft.com...
>
>
|||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@.discussions.microsoft.com> wrote in message
news:CDB44275-9E6D-4BC7-AB9F-5AC68D0ECF77@.microsoft.com...[vbcol=seagreen]
> 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:
|||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:

> 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@.discussions.microsoft.com> wrote in message
> news:CDB44275-9E6D-4BC7-AB9F-5AC68D0ECF77@.microsoft.com...
>
>
|||My MSN is lewisteo@.hotmail.com
"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@.discussions.microsoft.com> wrote in message
> news:CDB44275-9E6D-4BC7-AB9F-5AC68D0ECF77@.microsoft.com...
>
>
|||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@.discussions.microsoft.com> wrote in message
news:60368F4E-899E-4833-9ED6-591FF5A3535C@.microsoft.com...[vbcol=seagreen]
> 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:
|||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:

> 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@.discussions.microsoft.com> wrote in message
> news:60368F4E-899E-4833-9ED6-591FF5A3535C@.microsoft.com...
>
>
|||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@.discussions.microsoft.com> wrote in message
news:1D291D57-DB1E-439B-806C-91F4D83673DF@.microsoft.com...[vbcol=seagreen]
> 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: