Re: Active/Active/Active without SAN

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:60368F4E-899E-4833-9ED6-591FF5A3535C@xxxxxxxxxxxxxxxx
> > 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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> >> news:CDB44275-9E6D-4BC7-AB9F-5AC68D0ECF77@xxxxxxxxxxxxxxxx
> >> > 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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> >> >> news:3C882765-40EE-424E-8BEF-A5F768D2207D@xxxxxxxxxxxxxxxx
> >> >> >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.
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>
.

Relevant Pages

  • Re: AWE - SQL Server 2000 - Memory usage
    ... AWE only works when you have more that 4 GB... ... "Geoff N. Hiten" wrote: ... >>> Senior Database Administrator ... >>> Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.setup)
  • Re: AWE - SQL Server 2000 - Memory usage
    ... >> Geoff N. Hiten ... >> Senior Database Administrator ... >> Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.setup)
  • Re: Create databases in a cluster
    ... Availability Database Solutions using Microsoft SQl Server 2005, ... Senior Database Administrator ... So I left to train myself and seek advice from experienced cluster ... "Geoff N. Hiten" wrote: ...
    (microsoft.public.sqlserver.clustering)
  • Re: AWE & PAE Assistance
    ... I agree totally with Geoff on this. ... >>> Windows 2000 Advanced Server gives you up to 8GB memory. ... >>> Senior Database Administrator ... >>> Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.setup)
  • Re: Cut & Paste problems
    ... Geoff ... > When you want to paste and copy from the internet into Word, ... I am also running Word 2000 as part of Office XP. ... >> Genuine personal replies please remove Z from address line ...
    (microsoft.public.word.general)