Re: Active/Active/Active/Passive and Database Mirroring

Tech-Archive recommends: Fix windows errors by optimizing your registry

Instances are installed to the entire cluster, but can be set to prefer
certain nodes. I personally like N-1 clusters (N nodes, N-1 Instances),
just to simplfy management, but other that is not an absolute, inflexible
standard.

Each instance has completely separate resources; IP address, Data disks, Log
Disks, TempDB, and Network Name. Each instance works and appears as a
separate and distinct SQL Server.

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



"Chad T" <ChadT@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B13AE62F-89A3-405F-9F14-FE979336CC7B@xxxxxxxxxxxxxxxx
We have 4 systems that was initially planned to be joined into an
Active/Active/Active/Passive cluster with SQL 2005.

Can anyone offer a suggestion on the number of instances to install per
node?
Does each instance need seperate Disks for the Database, Logs and TempDB?
If we stay with this configuration will Database mirroring still be an
option with the configuration once it is supported by MS.



.

Relevant Pages

  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
  • RE: Installing SP4 on SQL 2000
    ... SQL Server 2000 SP3a, x86 ... It seems like there is issue on your install. ... MCITP: Database Administrator ... "David G" wrote: ...
    (microsoft.public.sqlserver.setup)
  • Re: Installing sp2 on active/passive cluster
    ... I want to install CU4 Build 3200, but I didn't see any instructions with it. ... I really have no cluster experience. ... Microsoft SQL Server MVP ... Do not end any running processes before you run the SP2 Setup program. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... Now, for the first problem, adding the 3rd node as a member of the cluster. ... You then installed a 2nd instance of SQL Server. ... DBC01 (Disks, SQL Server resources) ... Install RTM SS2K and designate the node membership. ...
    (microsoft.public.sqlserver.clustering)
  • RE: Installing SP4 on SQL 2000
    ... As you said this is a fresh install, so it should not be an issue. ... If you are installing are installing a fresh version of SQL Server 2000, ... MCITP: Database Administrator ... "David G" wrote: ...
    (microsoft.public.sqlserver.setup)