Re: Active/Active/Active without SAN

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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: SQL Server down
    ... Looks like you had a corruption in the master database. ... your SQL instance will not start no matter how hard the cluster tries to ... You may want to try to bring up the SQL instance without the ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL 2005 CLuster
    ... Using cluster administrator, bring everything online except SQL and the SQL Agent service. ... You can then follow the BOL instructions on how to rebuild a master database. ... At this point it works enough like a stand-alone SQL install for the instructions to work. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Changing Windows Domain
    ... Do not start SQL through the Services applet. ... prefer to use the Cluster admin tool. ... Make sure the service accounts have the ... >> Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • Error -2147217900: failed to create SQL database
    ... we rebuilt the SQL cluster network today. ... database: ApplicationDb, ... If the SQL instance services need to be restarted, ...
    (microsoft.public.sqlserver.clustering)
  • Re: DB Clustering or Load Balancing
    ... MS SQL server is a valid option for database clustering. ... The first step in installing MS SQL as a resource in a cluster configuration ...
    (microsoft.public.sqlserver.clustering)